Search your database quickly
SQL Search - quickly find SQL in SQL Server Management Studio
- Find fragments of SQL text within stored procedures, functions, views and more
- Quickly navigate to objects wherever they happen to be on a server
- Find all references to an object
SQL Search is an add-in for SQL Server Management Studio that lets you quickly search for SQL across your databases.
Currently SQL Search is a free tool, but we might charge for it in the future. If we do, the free version of SQL Search will still work.
Why use SQL Search?
- Impact Analysis
You want to rename one of your table columns but aren't sure what stored procedures reference it. Using SQL Search, you can search for the column name and find all the stored procedures where it is used.
- Work faster
Finding anything in the SSMS object tree requires a lot of clicking. Using SQL Search, you can press the shortcut combo, start typing the name, and jump right there.
- Make your life easier
You need to find stored procedures you've not yet finished writing. Using SQL Search, you can search for stored procedures containing the text 'TODO'.
- Increase efficiency, reduce errors
You are a DBA, and developers keep using 'SELECT *' in their views and stored procedures. You want to find all these and replace them with a correct list of columns to improve performance and prevent future bugs. Using SQL Search, you can look for 'SELECT *' in the text of stored procedures and views.
Finding objects with SQL Search
For large databases it's never been easy to find schema items and SQL Search is fast and unobtrusive, it's there when I need it and provides the results I need quickly.
David Sussman, ASP.NET consultant
"I use several stored procedures for various business tasks, all based on manufacturing floor activities. These are based, in turn, on the Station ID of individual test computers – I work for a consumer electoronics manufacturer, and we test our product at various stages of the process.
Management, in their infinite wisdom, decided that changing the Station IDs, so we could assign a block of them to vendors, was a good idea. This rendered many of my processes basically dead, because my where clauses were of the form
WHERE STID = x. Suddenly, nothing was getting returned and a lot of automation stopped. I had over a hundred procedures affected.
Using Red Gate's SQL Search, I found every affected procedure in just one hour, and was able to make all the pertinent changes to get all the automation flowing again. Thank you Red Gate!!!"
David Taylor, DBA
"We have had the occasion to move databases to a new server. SQL Search would make it easier to find all of the instances where the previous server was mentioned by name and correct them. This has also happened as data is moved to new databases and references to the old database need to be changed."
Lori Edwards, senior database administrator, Amadeus Revenue Integrity
"When a database contains several hundred objects, it can be a pain finding the correct table or remembering the name of an obscure stored procedure. With SQL Search installed, I no longer have to trawl through Management Studio's Object Explorer to find what I'm looking for - it is usually only a few keystrokes away."
Jeremy Skinner, senior software developer, The Sixth Form College Farnborough
Use SQL Search alongside the other 11 tools in the award-winning SQL Developer Bundle, and you’ll be able to code fast, drive greater collaboration, increase productivity, save time, and strengthen development processes. Sound good?
Got any questions?
+44 (0)1223 437 922
Start using SQL Search
It's completely free.