This will list out status of the trigger in a Database. This is compatible to SQL 2000 and 2005.
Script
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