I need to know when a DML trigger changes state (from enabled to disabled, and disabled to enabled).
I **assume** this info is not in any of the standard SQL Server 2005 loags and find no entry relating to triggers being enabled/disabled.
Therefore I also *assume* the best way to do this is create a DDL Trigger and populate a table when a trigger status is changed.
Am I on the right track?
Has anyone done this? Code samples/links to solution?
Is there a simplier way <i'm all about simple>?
Thanks in advance.
Thats exactly the right direction, if you need a quikc sample for using DDL events, take a look at the DDL event definition in the BOL and perhpas at the slightly different samples on my website: http://sqlserver2005.de/articles/2/HTH, Jens K. Suessmeyer.
http://www.sqlserver2005.de
No comments:
Post a Comment