Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin.
Search for scripts directly from SSMS, and instantly access any saved scripts in your
SSC briefcase from the favorites tab.
Download now (direct download link)
Thank this author by sharing:
By Saket Mittal,
Procedure to search any database (or a combination of databases, including all) for a specific strin...
Use this script to search objects in a Database. Also used to check a tables column types and detail...
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...
Searches for objects (including CLR) who's names contain the search string. outputs IDs, names, and ...
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.