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
714 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
You rated this post out of 5. Change rating
2001-08-22
714 reads
2001-08-22
366 reads
Very simple, how much space is free on the hard drives of the SQL Server you are connected to.
2001-08-22
652 reads
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
2001-08-22
399 reads
2001-08-22
699 reads