A few weeks ago "Dave the disruptor" posted about a free sql tool on the CF-Talk list. The tool is SQL Prompt from Red Gate Software and what it does is provide Intellisense for SQL Server's Query Analyzer.
I don't use SQL Server for personal development, but I just started a new job last week where I'm working on a fairly large enterprise application based on SQL Server so I decided to give this product a try. So far this tool has been a huge time saver. Instead of searching in the object explorer to find or remember an exact table or column name I just type the first few letters and up it pops. Fantastic.
The only thing I didn't like about the product when I first started using it was that it requires a separate login to the database to get the database's info. Not a big deal if you are only working with one database, but if you have several databases that you switch between like I do, all of the logins can get kind of annoying. Well it turns out that if you look under the Connections tab in the SQL Prompt configuration tool there is an option to "Use same credentials for all databases on same server." Problem solved.
So I have to say that so far I really like SQL Prompt and would definitely recommend this product to anyone who is working on an unfamiliar database or who just hates typing.