This SQL query will search for a specific keyword in all the stored procedures available.

1. declare @SearchTerm varchar(50)
2. SET @SearchTerm = 'keyword'
3. 
4. SELECT    
5.     ROUTINE_NAME,
6.     ROUTINE_DEFINITION
7. FROM    
8.     INFORMATION_SCHEMA.ROUTINES
9. WHERE    
10.     ROUTINE_DEFINITION LIKE '%' + @SearchTerm + '%'
11. ORDER BY
12.     ROUTINE_NAME