It is a very simple but useful SP to get Trigger and related table info especially on databases having large number of tables.
--Author: Krishna Sonti
--No INPUT or OUTPUT parameters
--Result Set -- Gives list of Triggers and related Tables
Create Procedure usp_Get_Tr_TableInfo
select [name] as TriggerName, object_name(parent_obj) as TableName from sysobjects where xtype = 'TR'
order by TableName