/*Searching for text in all stored procedures across data base*/
 
SELECT ROUTINE_NAME AS 'spName', ROUTINE_DEFINITION AS 'spContent'
FROM INFORMATION_SCHEMA.ROUTINES
WHERE (ROUTINE_DEFINITION LIKE '%something%') AND (ROUTINE_TYPE = 'PROCEDURE')

A personal technical diary… To the point… Precise