My co-worker Steve wrote this cool VS.NET add-in that adds SQL intellisense. I've used it at work and it seems to work pretty well. One bug that I'm aware of is the list of columns for a table doesn't display properly for an update statement. All in all a great tool. Check it out.
This hasn't been tested in VS.NET 2000 or 2005 so beware.
SqlAssist