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.