SP  to get Trigger and Table info

--Author: Krishna Sonti
--No INPUT or OUTPUT parameters
--Result Set -- Gives list of Triggers and related Tables

Create Procedure usp_Get_Tr_TableInfo
As

select [name] as TriggerName, object_name(parent_obj) as TableName from sysobjects where xtype = 'TR'
order by TableName