Try this.

SELECT ROUTINE_NAME, ROUTINE_DEFINITION

FROM INFORMATION_SCHEMA.ROUTINES

WHERE ROUTINE_DEFINITION LIKE '%foobar%'

AND ROUTINE_TYPE='PROCEDURE'

Replace foobar with the string you are searching inside a stored procedure.

This query lists out all the stored procedures in the databse which are using that particulat string.

Hope this helps.