Friday, May 7, 2010

Product Review: SQL Search - Searching for SQL Text Within SQL Server DB Objects

Some time ago Red Gate released SQL Search, a SSMS add-in that allows the user to search for fragments of text within database objects in a SQL Server instance! Yes, I know, this is cool! :)

There are many scenarios where the tool can come in handy. For example, imagine trying to perform a modification in a table and there is a view using the "WITH SCHEMABINDING" option which binds the view to the schema of the specific table. So, in order to be able to perform the table schema modification you will first need to either modify or delete the view. So what can you do for finding any views, functions or any other objects that reference the table? You can search for such database objects referencing the table name in their definition.

Below I am presenting some screenshots illustrating the usage of the tool.

After installing SQL Search and starting SQL Server Management Studio, you will notice that there is a new add-in added:


When clicking on the SQL Search add-in you are presented with the following screen:

The following screenshot explains the main controls of the tool:

For this example, I typed the text "customer" and searched for all the database objects, in all the databases within the instance that reference it. To this end I was presented with the following screen:

When clicking on a programmability item, i.e. a stored procedure, you are also presented with a preview of its T-SQL code that among other references the database objects having the provided text fragment:

Then, by double-clicking on the item, or by clicking on the "Select object in Object Explorer" hyperlink, you are able to access the object via SSMS Object Explorer:

Another important thing is that the tool is free and you can download it from here :)

I hope you found this product review useful!
Check out my latest eBooks on SQL Server:
Administering SQL Server - Ebook Tuning SQL Server - Ebook

Easily secure your SQL Server instances! Try out DBA Security Advisor!
DBA Security Advisor for SQL Server by SQLArtBits
DBA Security Advisor was developed by SQLArtBits. The tool was being carefully developed for an entire year and it contains comprehensive security checks and recommendations based on proven SQL Server security best practices. Feel free to download and use the Community Edition which is free and if you find it useful, you can consider upgrading to the Enterprise Edition!

Artemakis Artemiou [MVP]

Author & Editor

Artemakis Artemiou is a Senior SQL Server Architect, Software Developer and Microsoft Data Platform MVP. He is also an author, regular blogger, president of Cyprus.NET User Group and CY Country leader of INETA-EU. He is also the creator of DBA Security Advisor and In-Memory OLTP Simulator. Artemakis is a frequent guest author of worldwide well-respected online journals where he writes articles focusing on many SQL Server topics.

Reference: The SQL Server and .NET Hub (