Red Gate SQL Prompt
Red Gate published a little tool providing SQL Intellisense for free download until 1st September although you can use it afterwards for free.
After installation you should configure it using the Options Dialog Box to set the Intellisense "aggressivness". Nice tool anyway. There's just on little drawback: It runs as seperate application thus you have to provide your database connection details twice.