Normally to find out whether or not a trigger is enabled/disabled, we can simply run this:
SELECT OBJECTPROPERTYEX (OBJECT_ID(‘TriggerName’),’ExecIsTriggerDisabled’)
A DDL trigger, however, is not schema-scoped, therefore the above query will return NULL. To find out, here’s the query that you need to run:
SELECT name, is_disabled
FROM sys.triggers
WHERE name = ‘TriggerName’
Advertisement
