Find fragments of SQL in tables, views, stored procedures, functions, jobs, and more
Quickly navigate to objects wherever they happen to be on a server
Search across multiple object types and multiple databases
Find all references to an object
Search with booleans and wildcards
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 Object Explorer 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
Using SQL Search, you can look for SELECT * in the text of stored procedures and views and replace them with a correct list of columns to improve performance and prevent future bugs.
SQL Search integrates into SQL Server Management Studio and Visual Studio 2017
Pick the objects and databases you want to search
You get results as you type
Quickly jump to the found objects
“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.”
“For large databases it's never been easy to find schema items. SQL Search is fast and unobtrusive, it's there when I need it, and provides the results I need quickly.”
“SQL Search saves time and money for people and organizations! It’s an easy to use and efficient tool, allowing you to concentrate on more interesting and challenging things.”
“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
WHEREclauses were of the formWHERE STID = x. Suddenly, nothing was getting returned and a lot of automation stopped. I had over a hundred procedures affected.Using Redgate'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 Redgate!!!”
“SQL Search has saved me many hours of time, and a lot of frustration.”
Monthly newsletter
Get the latest best practices, insight, and product news from our industry experts
Get the newsletter
