...
This script provides a list of all enabled scripts for a given company:
SELECT sysobjects.name AS trigger_name, OBJECT_NAME(parent_obj) AS table_name,
OBJECTPROPERTY(id, 'ExecIsTriggerDisabled') AS [disabled]
FROM sysobjects
WHERE sysobjects.type = 'TR' AND sysobjects.name LIKE '%_CDC'
and OBJECTPROPERTY(id, 'ExecIsTriggerDisabled') = 0
ORDER BY disabled,sysobjects.name ASC
|
Enabled Triggers Query Results
...
If you need to enable triggers for a table not found in this list, run the following script to find the triggers for a given table not in the list and then go through Microsoft SQL Server Management Studio and manually enable the trigger:
SELECT sysobjects.name AS trigger_name, OBJECT_NAME(parent_obj) AS table_name,
OBJECTPROPERTY(id, 'ExecIsTriggerDisabled') AS [disabled]
FROM sysobjects
WHERE sysobjects.type = 'TR' AND (sysobjects.name LIKE '%_D_CDC' or sysobjects.name LIKE '%_IU_CDC')
and OBJECTPROPERTY(id, 'ExecIsTriggerDisabled') = 1
ORDER BY disabled,sysobjects.name ASC
|
Disabled Triggers Query Results
...
