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

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

Share on Facebook0Share on Google+0Tweet about this on TwitterShare on LinkedIn0Share on Reddit0
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!


Recommended eBooks on SQL Server:

Tuning SQL Server: eBook by SQL Server MVP Artemakis Artemiou
Tuning SQL Server: eBook by SQL Server MVP Artemakis Artemiou
Administering SQL Server: eBook by SQL Server MVP Artemakis Artemiou
Administering SQL Server: eBook by SQL Server MVP Artemakis Artemiou
Artemakis Artemiou
Artemakis Artemiou is a Senior SQL Server Architect, Author, Software Developer and a Microsoft Data Platform MVP. He has over 15 years of experience in the IT industry in various roles. Among other, via his initiative SQLEBooks.com, Artemakis authors and publishes eBooks on different topics on SQL Server. Artemakis currently serves as the President of the Cyprus .NET User Group (CDNUG) and the International .NET Association Country Leader for Cyprus (INETA). Additionally he is the founder of the SQLArtBits initiative that aims to provide the technical community with simple, yet powerful and high-quality SQL Server tools. Currently, the highlights of these tools are DBA Security Advisor and In-Memory OLTP Simulator. Artemakis's official website can be found atย aartemiou.com. Artemakis's blogs can be found at: SQLNetHub.comย and TechHowTos.com.