The original query analyzer object search tool in Sql Server 2000 was good for quickly locating database objects and analyzing database content. It also allowed Non-sql developers and analysts to easily examine metadata and find database objects without having to actually write any sql. For some reason, Microsoft dropped the tool in the mssql 2005 and 2008 releases, at least I never found it. I wrote this program to do the exact same thing for sql server 2005 and 2008. I've also added some features I find helpful. It's a work in progress so check back from time to time for updated versons with added functionality.
Sql Server Object Search Tool