Tuesday, October 30, 2007

Find Any String In SQL Server

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

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)