Round Polygons have released a Visual
Studio add-in called SQLAssist that
gives you SQL intellisense. It is currently in beta and available for both Visual
Studio 2003 and 2005.
In my brief assesment of the add-in it has a long way to go still. The intellisense appears
haphazardly and there are certain styles of SQL writing that it does not support.