SELECT DISTINCT so.name FROM syscomments sc INNER JOIN sysobjects so ON sc.id = so.id AND so.xtype = 'P' WHERE sc.TEXT LIKE '%TABLE_NAME%'
Monday, June 10, 2013
MSSQL: Get All Stored Procedures With References to a Table
AFAIK, there is no built-in feature to generate a list of stored procedures that made references to a specific database table. The following help me to do just that.
Subscribe to:
Post Comments (Atom)
Popular Posts
-
Get accurate and real-time bus arrival information for public bus operators in Singapore, including SBS Transit, SMRT Buses, Go-Ahead Singap...
-
According to the Firefox developer team, Firefox 3 will be launched on 17th June 2008. From the Firefox Developer blog, they are attempting ...
-
*********** Try to sleep now, close your eyes Soon the birds would stop singing Twinkling stars, are shining bright They'll be watch...
-
Google url shortener service, goo.gl , is now much improved with newly included features like easier copy and paste, and ability to delete e...
-
I would like to apologize that sigining of my guestbook is not possible at the moment due to an unexpected bug. There is already 74 entries ...
No comments:
Post a Comment
Do provide your constructive comment. I appreciate that.