sql Locate a Stored Procedure

SELECT 'Use ' +  name + ';SELECT * FROM sys.procedures Where name Like ''%amazon%'';' FROM sys.databases
Use this to try to locate a Stored Procedure with amazon in the name.

Updated: Saturday 9th October 2010, 07:47pm

There are 0 comments

Leave a comment of your own

Comments are currently closed.