On Premise and Cloud Database Knowledge Base

Trigger Status

This will list out status of the trigger in a Database. This is compatible to SQL 2000 and 2005.


SELECT a.name AS TableName,b.name AS TriggerName,
CASE OBJECTPROPERTY(b.id,'ExecIsTriggerDisabled')
WHEN 0 THEN 'Enabled' ELSE 'Disabled' END AS 'Status'
FROM sysobjects a, sysobjects b WHERE a.id = b.parent_obj AND b.xtype='TR'

Leave a Reply

Leave a Reply

Your email address will not be published.