Find a stored procedure containing
Posted by ken zheng on November 10, 2009
Quite often you need to find which stored procedure contains key word. I find this blog and use
SELECT ROUTINE_NAME, ROUTINE_DEFINITION
FROM INFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_DEFINITION LIKE '%foobar%'
AND ROUTINE_TYPE='PROCEDURE'
