Finding stored procedure table dependencies
By : Steve Eichert - Sql Server | On : 2003 June 11
Recently one of my co-workers dropped me an IM asking how he could find what stored procedures depended on a certain table. After a little digging we came up with the following query which will return a listing of stored procedures that depend on a particular table (T_TableName). selectdistinct so.name fromsyscomments sc inner joinsysobjects so on sc.id = so.id where xtype = 'P' AND charindex('T_TableName', text) > 0It would be cool if within SqlBuddy, VS.NET, SQL Enterprise Manager, (name your favorit...
|
|
|
Total:
 |
Click here to continue on details
Content Ownership
The content of this posting is wholly owned by Steve Eichert - Sql Server, and as such: the same retains sole copyright for the content. softlogger.com is not responsible for this content.
Recommended Related Readings :
Passing the ORDER BY to a stored procedure
I use stored procedures for a lot of the data access I do within the applications I develop. ...
Caching the Stored Procedure Parameters Discovered Using SqlCommandBuilder.DeriveParameters
Caching the Stored Procedure Parameters Discovered Using SqlCommandBuilder.DeriveParameters b...
Calling an Oracle Stored Procedure from a Sql Server 2000 Stored Procedure using a Linked Server
I had to to this a while back -> Calling an Oracle stored procedure from a Sql Server stored p...
Retrieving Scalar Data from a Stored Procedure
IntroductionVirtually all ASP.NET applications of interest work with database data at some lev...
Passing a DataSet to a SQLCLR Stored Procedure
Is it possible to pass a DataSet to SQL and process the data in a SQLCLR stored procedure? Thi...
The CLRUD Design Pattern for CLR Stored Procedures (C#, VB.Net)
Overview Using CLR Stored Procs is a decision to be made for a multitude of reasons, not ...
