How do I find all stored procedures containing the following text: xyz
Oct 11, 2009
Run the following sql in a query window. Make sure to substitute the xyz. *Note, when you copy this, the single quotes may change. So, if it crashes when you run it, replace the single quotes with actual single quotes.
SELECT ROUTINE_NAME, ROUTINE_DEFINITION
FROM INFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_DEFINITION LIKE ‘%xyz%’
AND ROUTINE_TYPE=’PROCEDURE’
