A: 

If you can use the SQL client tools, "Intellisense" is included in Management Studio for SQL Server 2008 already.

edit: For formatting, you can also use SSMS Tools Pack but again it's SSMS only...

gbn
Trying to manage copy-and-paste back-and-forth between SSMS and VS is way too error prone for me. I do my coding in VS, deploy from there to SQL using auto-generated scripts, and use SSMS only for debugging or maintenance.
RickNZ
I tend to work only in SSMS because I'm a developer DBA (although many of my colleagues do too, but we use Red Gate pro)
gbn
+1  A: 

You could also download the trial of SQL Assistant to see if it fits your needs. It works in VS2008. I purchased and used it before I got the Red Gate tools and actually liked it. It's only $149.

GregD
I downloaded the trial, and I'm working my way through it. Better than SQL Prompt so far, on the formatting side at least. However, it's still surprisingly buggy for a commercial tool: poor support for MERGE and Service Broker commands, for example.
RickNZ