Red Gate has created a SQL Server tool to add search functionality to SSMS. This will not only search object names but also the object code. The team would like you to try it out and give them your feedback.

The tool is not perfect yet. I have been told that the team wrote the tool in a single week. I have been using it for a couple of days and I am quite impressed.

The beta build can be found here: www.red-gate.com/products/sql_search/index.htm.

Because the product is still in beta, it is free. I have no clue yet how much they will charge for it.