Last week I discovered this really neat application from Red-Gate Software, makers of some really nice MSSQL tools such as "SQL Compare" and "SQL Data Compare". They have released a free third party add-on that adds Intellisense® style auto-completion to Microsoft SQL Server editors.

This tool runs on the background and works with Microsoft Query Analyzer, SQL Server 2005 Management Studio, Visual Studio 2005, Visual Studio .NET 2003, SQL Server 2000 Enterprise Manager, UltraEdit32

Features include :

• Table/View name completion
• Column name completion
• Stored procedure name completion
• USE completion
• JOIN/JOIN ON completion
• Auto-uppercasing of keywords
• Auto-popup after keywords

You can get more info and download it from Red-Gate Software's Site