Is there a way to scan StroredProcedure text looking for given string 2

[WantsToLearn]

Hello,

We have many, many stored procedures and I need to find a couple that have a specific piece of code in them. Is there any way to globally search the stored procedures in this manner? Thanks!

 

[mercwrought]

HERE

 

[hmckillop]

Alternative way, but essentially uses the same method is shown in the FAQs with an procedure entitled sp_search_code

Have a look at:

http://www.tek-tips.com/faqs.cfm?fid=5175

"I'm living so far beyond my income that we may almost be said to be living apart