SQL Search is a free add-in for SQL Server Management Studio (SSMS) and Visual Studio (VS) that lets you search for SQL in your databases. You can:
- find fragments of SQL in stored procedures, views, jobs and more
- quickly navigate to objects anywhere on a server
- find all references to an object
You can download SQL Search for SSMS from the SQL Search product page.
SQL Search for VS will be delivered as part of the VS 2017 installation.
Supported Visual Studio versions
- Visual Studio 2017 RC with SSDT (see note below)
SQL Server Data Tools (SSDT) required
In Visual Studio 2017, SQL Server Data Tools (SSDT) is not installed by default. In order to use SQL Search with VS2017, you must first run the Visual Studio installer and select the Data Storage and Processing workload (which includes SSDT).