SP  to get Trigger and Table info

,

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
As

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

Rate

Share

Share

Rate