It is a very simple but useful SP to get Trigger and related table info especially on databases having large number of tables.
2001-08-22
690 reads
Krishna Sonti,
2002-09-19
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
Very simple, how much space is free on the hard drives of the SQL Server you are connected to.
Get OLE Providers info I have found this useful in tracking down application driver/connection issues. I only had to use it 2 times. But it did help