Here is a simple SQL query that will look in your stored procedures and return any that finds “yourtext”.
SELECT ROUTINE_NAME, ROUTINE_DEFINITION
FROM INFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_DEFINITION LIKE '%yourtext%'
AND ROUTINE_TYPE='PROCEDURE'
a286bb73-4243-448c-9ca0-0b04020ae170|0|.0
.Net