Thank this author by sharing:
By Press Release,
BDS SQL Digger is a FREE small search engine for MS SQL Server.
This tool enables you to search through all your Stored Procedures, Views, UDF’s and Triggers for a word, multiple words or a sentence.
It not only finds the objects where you used the search strings, but it also shows you where exactly it is located inside the TSQL by highlighting it in a preview screen.
It also allows you to simply drag and drop the contents of any found object to any receiving container (Query Analyzer, Word…).
BDS SQL Digger 2.0 now comes with an added print functionality together with Multi Database Search.
More info and download: http://sqldigger.bdsweb.be
Have you ever needed to find something in a stored procedure or function and found yourself trying t...
Procedure to search any database (or a combination of databases, including all) for a specific strin...
Ever been in the situation where you know that you used a function in a stored procedure and couldn'...
Edit the @SearchText and you can enter any text you would like to search for in SQL Objects.
There are other options available like Sql search from Red Gate. Here's a simple script to search fo...
As a member of SQLServerCentral, you get free access to loads of fresh content: thousands
of articles and SQL scripts, a library of free eBooks, a weekly database news roundup,
a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals
that makes it such a success.