Search through text of Stored Procedure

Search across the text of all stored procedures for a particular string.
Author: Nate Baxley
Published Date:4/9/2008
SELECT ROUTINE_NAME, ROUTINE_DEFINITION
FROM INFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_DEFINITION LIKE '%foobar%'
AND ROUTINE_TYPE='PROCEDURE'
RSS Feed Log In to access RSS feeds.


Remember me on this computer

This Item Tagged as

Hover over an item above for
more information