Free SQL Server Intellisense Add-In
Red Gate Software has purchased SQL Prompt. It is an add-in that adds SQL Intellisense to SQL 2005, VS 2005, SQL 2000 and VS 2003.
While they are working on a new version they have made the older version free, so grab it while you can. The free version goes away in September.
http://www.red-gate.com/products/SQL_Prompt/index.htm