is there a SQL Prompt like plugin for VS 2008

Question

I like to use the SQL Tools in VS but I would like to have some intellisense for SQL, with sql manager I can get the Redgate SQL prompt but I would like to stay in VS, any Ideas?

Edit: is there anything other then Redgate SQL prompt? that dose error checking like the way R# or dev express?

Answer 1

Red-Gate SQL Prompt (at least more recent versions, I believe 3.x and up) also works inside Visual Studio. I don't think you need another extra tool, really.

See the Red-Gate SQL Prompt feature page

It says clearly:

Integrates with SSMS, SSMS Express, Query Analyzer and Visual Studio

Marc