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)