Find SQL Server is an add-on to Microsoft SQL Server Management Studio that lets you quickly find SQL objects, records, and even text within your databases.
If a database comprises many objects, finding the required table or recalling the names of stored routines is an overwhelming task. When you use Search for SQL Server, you do not have to browse through the SSMS Object Explorer to locate the name of a required column or text within the stored procedure. The database search tool is sure to simplify your life.
Search for SQL Server has two modes: DDL and Data modes. Having chosen the mode, you can then customize your Search by setting up search criteria:
You can quickly search numerous object types across multiple databases simultaneously. This option also allows simultaneous search across multiple database object types:
Search for SQL Server helps save time and extend productivity.
Search for SQL Server allows you to sort search results according to your needs. With the tool, you can:
the results in a grid for convenient use.
You can find an object by name in a SQL Server database, and Search will identify all objects containing the search query, including the stored routines.
Search for:
The tool will search across both objects' names and bodies.
Search for SQL Server includes the Data Search Mode allowing to locate the table, view, stored procedure, function, trigger, etc., containing the required data and then view this data.
For convenience, the results will be displayed in a grid, where you can check:
You can use wildcards to substitute any character in a search string. With wildcards, you can match zero or more characters, a set of characters included or absent in an object name being searched, etc.
Using the wildcard search feature, you can maximize your search results.
Using Search for SQL Server, you can find a specified SQL code fragment in tables, views, stored procedures, functions, triggers, etc. For example, searching for a "alter" command will return examples of all code fragments containing the command.
This feature allows you quickly locate an object rather than browsing through a list of objects in the Object Explorer. With this database search tool, you can jump to the found object in Object Explorer with a single click.
Finding anything in the Object Explorer regularly requires a lot of time and eye strain. You can eliminate those using Search for SQL Server and navigate to the found object in a flash.