You can get a report on a trigger using sp_help. For example, you can get information on deltitle as follows:
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)
