sp_depends

sp_depends lists the triggers that reference an object, or all the tables or views that the trigger affects. This example shows how to use sp_depends to get a list of all the objects referenced by the trigger deltitle:

sp_depends deltitle 
Things the object references in the current database. 
object              type       updated  selected 
----------------    ----------  ------- -------- 
dbo.salesdetail     user table  no      no
dbo.titles          user table  no      no
(return status = 0)

This statement lists all the objects that reference the salesdetail table:

sp_depends salesdetail 
Things inside the current database that reference the object.
object                       type         
---------------------------  ----------------  
dbo.deltitle                 trigger         
dbo.history_proc             stored procedure  
dbo.insert_salesdetail_proc  stored procedure
dbo.totalsales_trig          trigger 
(return status = 0)