SQL Server: check whether a Trigger is Enabled or Disabled?
How we can see which Trigger is Enabled or Disabled in SQL Server 2008?
Solution 1:
Using sys.triggers
SELECT name, is_disabled FROM sys.triggers
Solution 2:
In big databases you usually don't know the table for the trigger.
SELECT OBJECT_NAME(parent_id) [table_name],[name] [trigger_name],is_disabled
FROM sys.triggers