Trigger Status

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


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

Leave a Reply

Leave a comment

Your email address will not be published. Required fields are marked *