Red Gate - SQL Prompt
Red Gate make some pretty cool tools for SQL Server. Now most of them cost some money, not a lot specially considering what you get but still they aren't free.
Now they have a new add that provides IntelliSense for SQL commands. And not only the keywords but also the table, columns and pretty much everything you need. And it works with a host of environments: Query Analyzer, SQL Server 2005 Management Studio, Visual Studio 2005, Visual Studio .NET 2003, SQL Server 2000 Enterprise Manager and even UltraEdit32. And best of all, it is free until September 1st.