Wednesday 27 August 2008

Finding All Stored Procedures Containing Text

SELECT ROUTINE_NAME, ROUTINE_DEFINITION
FROM INFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_DEFINITION LIKE '%searchtext%'
AND ROUTINE_TYPE='PROCEDURE'
Posted by at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)