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
I use SQL Search regularly and think it's great.Gregor Suttie, Senior Software Engineer, Pulsion Technology
It's just great to have a good search tool within SQL Management Studio. 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
SQL Search provides a number of benefits: it's helpful that it was designed to work within SSMS; after the initial indexing, the search response is fairly quick; the ability to navigate directly to the object within Object Explorer is very helpful as is the ability to select what type of objects to search on. 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
The great thing about SQL Search is that it allows me to navigate very quickly around our databases. 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. While this may only save a few seconds, this can quickly add up throughout the course of a day.Jeremy Skinner, senior software developer, The Sixth Form College Farnborough
Can we start spreading the word? This tool is damn too good to keep it secret. It's incredible in letting you search the objects of your databases for anything you can think of, and maybe even more!Eric Moreau, senior consultant, Moer Inc.