Aug 8, 2012

Seaching for a matching Text in Stored Procedure SQL Server

I had a rough time, open each stored procedure in my MS SQL Server 2005 and then looking for the text that i needed to change. Then i finally came to a very short query but yet so helpful:

SELECT object_name(id)
FROM syscomments
WHERE text LIKE '%Text%'

No comments:

Post a Comment