Searching a string in SQL server 2005 -

Posted on March 17, 2012 by Prady

It is very tedious to find out all Database objects (functions, stored procedures) containing a particular string.

Here is the script to get it-

DECLARE @Search varchar(255)

SET @Search='texttofind'

SELECT DISTINCT o.name AS Object_Name,o.type_desc
FROM sys.sql_modules m
INNER JOIN sys.objects o ON m.object_id=o.object_id
WHERE m.definition Like '%'+@Search+'%' ORDER BY 2,1
This entry was posted in Knowledge Sharing, SQL Server, Troubleshooting. Bookmark the permalink.

4 Responses to Searching a string in SQL server 2005 -

  1. Anonymous says:
    November 23, 2011 at 6:12 pm

    I like this post, enjoyed this one thankyou for putting up.

  2. Louis Vuitton Sale UK says:
    November 20, 2011 at 2:06 am

    Thank you for sharing your issues on weblog. it’s most most likely that we have comparable interests. 1 factor are highly valuable to me.

  3. CruzHopkins says:
    November 19, 2011 at 8:17 pm

    Hi there! Do you use Twitter? Iâ??d like to follow you if that would be okay. Iâ??m definitely enjoying your blog and look forward to new posts.

  4. Replica Handbags says:
    November 18, 2011 at 8:03 pm

    Thank you for the good writeup. It in fact was a leisure account it. Glance complicated to more delivered agreeable from you! However, how could we communicate?

Leave a Reply