Red Gate Software has released the 1.0 beta version of SQL Search, a new free SSMS add-in that allows you to easily search for “text strings”, allowing you to quickly find objects stored within a SQL Server instance.
For example, if you want to find all of the objects on a SQL Server instance that have the string “orders” in it, this is easily done, as you can see below.
Besides displaying all of the relevant objects, it also provides the T-SQL code that was used to create the object.
When the final version comes out (which will also be free), I’ll provide a longer description of how you to use the tool. But in the meantime, the beta version works very well and can be put to immediate use. Download SQL Search here.



Subscribe to this blog
Briefcase
Print
Posted by Dugi on 28 January 2010
Wow it works very fine and very fast!
Posted by Anonymous on 28 January 2010
Pingback from Dew Drop – January 28, 2010 | Alvin Ashcraft's Morning Dew
Posted by Tim Mitchell on 28 January 2010
Looking forward to trying this out! I've built scripts over the years to do this, with some success, but a well-built GUI should be much easier to deploy and use.
Posted by Siddharth Mehta on 2 February 2010
Very nice add-in. Next best after SSMS Tools Pack.