Is TRIGGER Enabled or Disabled? 1

[MeanGreen]

Does anyone know how to tell if a trigger has been disabled? I found that "STATUS" within sysobjects does change value, but no real pattern that I can tell. I checked all the stored procedures, but found nothing. I looked in BOL and on Microsoft Web site, but found nothing. I have always steered clear of disabling a trigger, but I think someone might have disabled a tracking trigger on the system. It is easy enough to enable, but I want to be able to run a script to find all triggers that have been disabled.

Thank you!

 

[tlbroadbent]

SELECT OBJECTPROPERTY(OBJECT_ID('Trigger_Name'),
'ExecIsTriggerDisabled') will return 1 if the trigger is disabled - 0 if enabled.
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm

If you want to get the best answer for your question read faq183-874.