8.8.10

find text in all sp of a particular sql database.

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

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)