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'