Rossana A. Hnatyshyn (8/8/2013)
Can you make it where you can search accross databases in current connection?
Didn't actually get your question, could you please elaborate?
Usually what I do is create a short cut to call this SP. After that just highlight the string you want to search and hit the short cut key.
One of the greatest advantage of this approach is that we can find out dependencies for objects where dynamic queries are involved. Just provide the search string and it will be searched across all programmable objects across your database.
Also, if you run this SP in master database you can use it across any database in your server.