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.