Method to retrieve every text inside the stored procedures of a database
Reference: http://geekswithblogs.net/whiletrue/archive/2009/02/02/find-text-in-sql-stored-procedures.aspx
SELECT B.Name, *
FROM syscomments A INNER JOIN sysobjects B
ON A.id = B.id
WHERE A.text like '%tblNames%'
FROM syscomments A INNER JOIN sysobjects B
ON A.id = B.id
WHERE A.text like '%tblNames%'
No comments:
Post a Comment