When no of procedures are more, its dificult to find out the name of procedures where a paricular keyword is used like, i want to know the name of procedures where the keyword status or a column status is used.
To acheive this following code can be used:
SELECT ROUTINE_NAME, ROUTINE_DEFINITION
FROM INFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_DEFINITION LIKE '%status%'
AND ROUTINE_TYPE='PROCEDURE'