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
-
新加坡人口400万，亚洲人口4亿，全世界人口6亿。 但是，我一人可能就很有可能是世界最傻的了。我真是个不折不扣的大木头。真是受不了自己。
-
I was at Bugis Junction today and saw 蘇打綠 (Soda Green) performing. They look so much different especially the lead singer. I find their song...
-
Pledge to finish my 1st task after my 2 full days of rest by today. 03 March 2010 : CS4236 Project deadline It is basically a "waste-t...
-
Despite the implementation of a mandatory plastic bag charge in local supermarkets in July 2023, recent data reveals that consumers still pu...
-
I recently wrote a code snippet to fill arrays with a value. The below method is a generic method that will accept different data types. Hop...
No comments:
Post a Comment
Do provide your constructive comment. I appreciate that.