Here is a stored procedure written by Narayana Vyas Kondreddi that I use to find a specific string in all the stored procedures and functions in a database.

create procedure dbo.sp_search_code

--drop...