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.
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.
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.
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.
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.
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.