SQL-How to Search String in all Stored Procedures across All User Defined DB(s)

There are many different ways to accomplish this tasks. The below examples uses undocumented sp’s to loop through all the user defined database to search the SP’s using given string SCRIPT 1 -- without Search String Parameter but you need to change the search pattern in SQL(R

SPSearch.sql
 
 
 
 
 
(0)
457 times
Add to favorites
Databases
2/24/2015
E-mail Twitter del.icio.us Digg Facebook
Sign in to ask a question


Be the first to ask a question.