dbForge Object Search for SQL Server is a free add-in for SQL Server Management Studio that allows you to search SQL objects and data in your databases.
It can be very difficult to find a required table or to remember names of your stored routines, when a database contains lots of objects. With dbForge Object Search for SQL Server you no longer need to look through the entire SSMS Object Explorer to find a required object.

Key Features:

Check References Search. You can search a database object by name, and Object Search will find all the stored routines involving this object. This feature allows to quickly locate an object rather than browsing through a list of objects in the Object Explorer.

Custom Search. You can customize your search by setting up search criteria: object type, database, and connection. The search filter allows to quickly find only the specific object you need.

Multiple Search. You can quickly search numerous object types across multiple databases at the same time. This option allows simultaneously search in such database object types as functions, triggers, columns, etc.

Wildcard Search. You can use wildcards to substitute for any characters 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.

SQL Fragments Search. Using dbForge Object 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 "select" command will return examples of code fragments containing the command.

Data Search. dbForge Search includes the data search mode allowing to locate the table and view data corresponding to the search string.

Support for SQL Server 2016.

Integration into SSMS 2016.