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%'
Computer, Technology, Databases, Google, Internet, Mobile, Linux, Microsoft, Open Source, Security, Social Media, Web Development, Business, Finance
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)
No comments:
Post a Comment
Do provide your constructive comment. I appreciate that.