Recommendations for SQL Server 2005 IntelliSense tools/add-ins?

I am your average Visual Studio .NET developer who has become dependent on Intellisense and Pre-compile syntax checking.

I am looking for similar Intellisense functionality for MSSQL Server 2005 and T-SQL

I was wondering what editors or add-ins people have had success with and would be happy to recommend. What key features do you use regularly, and what are any weaknesses?

From stackoverflow

• Red Gate makes a product that works with 2000, 2005, and 2008, called SQL Prompt. It has the same/better functionality than Intellisense. It integrates with Management Studio and Query analyzer.

  http://www.red-gate.com/products/SQL_Prompt/index.htm

  Giovanni Galbo : Doesn't 2008 have intellisense? Is red gate's any better?

  Nathan DeWitt : I love SQL Prompt. It's an excellent product. The entire toolbelt from Red Gate is amazing.

  GluedHands : Yes 2008 has intellisense, but it only works for SQL 2008 databases that you connect to.

• SQL Prompt is very good, however you could install the SQL Server 2008 client tools.

  John Mo : SQL 2008 intellisense only works on 2008 instances. Most of the other tools work with older versions.

• ApexSQL's Edit tool has intellisense and many other features I find very handy. They offer many other tools that I've found to be productivity boosts. Highly recommended. See: ApexSQL

• print("code sample");We are currently using SQL Assistant from SoftTreeTech. It has some fantastic features and keeps on growing.

  I would be interested to see if anyone has used ((Apex OR RedGate) AND SqlAssist) and could provide an objective comparison?

  Find Details here: SqlAssist

  John Mo : I'm sold on Apex's stuff and haven't used SQL Assistant, so it's hard to be objective. It looks to me like SQL Assistant would be a good deal if you work in multiple database engines. I think for SQL Server only, you get more for the extra $50 with the Apex Edit tool. Free to try Apex. Check it out.