dbForge SQL Complete is a useful add-in for SQL Server Management Studio 2000, 2005 and 2008 that offers powerful autocompletion and formatting of T-SQL code.
Besides extending List Members, Complete Word and Parameter Info features, SQL Complete adds SQL Formatter to enrich the developer toolkit and provide the fastest T-SQL query typing ever possible.

Features of dbForge SQL Complete:
* Context-based code completion;
* Smart filtering to suggest relative keywords and objects;
* Quick parameter info for functions;
* Customizable SQL formatting;
* Context-based sorting of suggestions in the list;
* Determining a current database or schema;
* Expanding a list of columns;
* Suggesting conditions for JOIN statements;
* Automatic alias generation;
* Suggestions of T-SQL statements in procedures and functions;
* Semi-transparent view of the suggestion box.

Besides the extended Standard version, SQL Complete has a free version with free intellisense and basic SQL formatting functionality to speed up writing SQL statements.
SQL Complete provides intellisense for SQL Server 2000, 2005, 2008, regardless of SSMS versions. Native intellisense does not work with those SQL Server versions that differ from your SMSS version. For example, SQL Server Management Studio 2008 will work only with SQL Server 2008.