Red gate have released an intellisense application that works with SQL editing tools including enterprise manager and Management Studio.
The application sql prompt (http://www.red-gate.com/products/sql_prompt/index.htm) is currently free.
I have spent the last 15 minutes trying it out and came to the conslusion that I'm glad its free because I wouldn't want to pay for it.
I have tried to give it its dues but it falls down in the following areas.
Its too slow, it takes too long for the list to display, I can type the details quicker. This is especially true with the join section.
Its buggy, I found it got lost in its context only displaying tables that join to a table I had previously deleted. It also wouldn't select a table when pressed enter on a number of occasions.
The key strokes are different to that in VS, which means I have to manage two sets of key strokes.
Simply put, the aim of intellisense is to improve coding efficiency. This doesn't it may do sometimes but the occasions that it fails, is too slow when you are epxecting it just negate any benefit you could achieve.
You can really see why MS had issues with including it in management studio and so was pulled.