M. FAISOL RIZA

This is the way how to find stored procedure containing some text. We can search with table name or other sql object name.

SELECT ROUTINE_NAME, ROUTINE_DEFINITION
FROM INFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_DEFINITION LIKE '%blablabla%'
AND ROUTINE_TYPE='PROCEDURE'

Thank you. Hopefully it is useful for you