Search

Wednesday, August 1, 2012

Search a table used in all SP

You can search for a table used in all the stored procedure. It is a very basic information but makes it easy while making changes to a table name and like to change the procedures using the table.


SELECT '[' + SPECIFIC_CATALOG + '].[' + SPECIFIC_SCHEMA + '].[' + SPECIFIC_NAME + ']', ROUTINE_DEFINITION
FROM INFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_DEFINITION LIKE '%STRING%'

No comments:

Post a Comment