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’

  • Share/Bookmark
 | Posted by admin | Categories: Databases | Tagged: find all stored procedures |
WordPress SEO fine-tune by Meta SEO Pack from Poradnik Webmastera