“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 and SQL Search is fast and unobtrusive, it's there when I need it, and provides the results I need quickly.”
“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 electronics 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
WHEREclauses 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!!!”
“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.”
See why Chris Yates relies on SQL Search to search through objects in his 1500 databases.