Printable View
I've looked in several books in addition to the online SQL Server documentation, and I can't find a way to determine whether or not a trigger is enabled or disabled. I know how to enable/disable, I just can't figure out the current status of the trigger. It's not returned in sp_help or sp_helptrigger, and there's no indication in Enterprise Manager of a trigger's status. Does anyone out there know how to do this?
Only thing I could find concerned recursive triggers as a db option. This statement:
sp_dboption '<database_name>', 'recursive triggers'
will return an 'on' or 'off' status. This, of course, is database-wide.
------------
Pete at 2/15/2002 4:06:15 PM
I've looked in several books in addition to the online SQL Server documentation, and I can't find a way to determine whether or not a trigger is enabled or disabled. I know how to enable/disable, I just can't figure out the current status of the trigger. It's not returned in sp_help or sp_helptrigger, and there's no indication in Enterprise Manager of a trigger's status. Does anyone out there know how to do this?