3 Answers
3

That's probably not a good idea for use in an actual application though. If I have a few minutes I'll try to dig up a cleaner way. The above will also catch procs that have that string commented out, it uses the MS SQL Server specific table syscomments, etc.

Thanks, but I already have something for general search - mine uses a CTE and gives individual lines (for multiple occurrences) and a snippet of code around the occurrence.
–
Cade RouxJan 12 '09 at 16:46