dbForge Search is a FREE add-in for SQL Server Management Studio that allows you to search SQL objects, data, and text 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 Search, you no longer need to look through the entire SSMS Object Explorer to find a required column name, or text in a stored procedure.
It is important to note that dbForge Search does not change objects or data while performing search.
Note
dbForge Search utilizes the WITH(NOLOCK) hint in queries. It means that queries to be executed will use a READUNCOMMITTED isolation level, preventing locks on data reading. However, it should be noted that NOLOCK may lead to dirty reads, including uncommitted or modified data by another transaction, and inconsistent results.