I have mentioned previous how I enjoy working with Red-Gate software, they have done it again and this time it's free. Now you can get Intellisense for SQL inside Query Analyzer, Enterprise Manager, SQL Server Management Studio and Visual Studio 2003/2005. Here's a screenshot:

Download it here.