Get a report on a trigger using sp_help. For example, you can get information on deltitle using:
sp_help deltitle
Name Owner Type ----------- ------- ----------- deltitle dbo trigger Data_located_on_segment When_created ----------------------- ----------------- not applicable Jul 10 1997 3:56PM (return status = 0)
You can also use sp_help to report the status of a disabled or enabled trigger:
1> sp_help trig_insert 2> go Name Owner Type ------------------------------------ trig_insert dbo trigger (1 row affected) data_located_on_segment When_created ------------------------------------ not applicable Aug 30 1998 11:40PM Trigger enabled (return status = 0)
