If you have triggers running against your database tables then you probably want to make sure they are turned on or off at the right times. Here's a script to check the status of your triggers.
SELECT db_name() AS [Database Name],
T.[name] AS [Table Name],
TR.[Name] AS [Trigger Name],
[Status] = CASE WHEN OBJECTPROPERTY(TR.[id], 'ExecIsTriggerDisabled') = 1
THEN 'Disabled' ELSE 'Enabled' END
FROM sysobjects T
JOIN sysobjects TR ON t.[ID] = TR.[parent_obj]
WHERE T.[xtype] = 'U'
AND TR.[xtype] = 'TR'
SELECT db_name() AS [Database Name],
T.[name] AS [Table Name],
TR.[Name] AS [Trigger Name],
[Status] = CASE WHEN OBJECTPROPERTY(TR.[id], 'ExecIsTriggerDisabled') = 1
THEN 'Disabled' ELSE 'Enabled' END
FROM sysobjects T
JOIN sysobjects TR ON t.[ID] = TR.[parent_obj]
WHERE T.[xtype] = 'U'
AND TR.[xtype] = 'TR'
No comments:
Post a Comment