In SQL Server Management Studio can I search for assets across multiple databases?

Question

My everyday IDE is Eclipse which has a wonderful Open Resource feature (CTRL+SHIFT+R or Navigate > Open Resource) which allows the user to search for files/resources across multiple projects.

I can't find a similar feature in SQL Server Management Studio, is there one?

Answer 1

I believe this is what you are looking for: http://www.red-gate.com/products/sql-development/sql-search/

It is completely free, and completely awesome.

_{(source: red-gate.com)}