SELECT
ROUTINE_NAME, 
ROUTINE_DEFINITION 
FROM        
INFORMATION_SCHEMA.ROUTINES 
WHERE        
ROUTINE_DEFINITION LIKE '%whatev%' 
ORDER BY  ROUTINE_NAME

Search Stored Procedure for String

sql, search

SQL