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?
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: http://www.red-gate.com/products/SQL_Prompt/index.htm
It says clearly:
Integrates with SSMS, SSMS Express, Query Analyzer and Visual Studio
Marc
Yes, SQL Prompt 3.x and 4.x beta for sure work with Visual Studio 2005/2008
You can download the 4.x beta to play with, and visit their forum if you have any question/problem. Red Gate people are very nice and helpful http://www.red-gate.com/MessageBoard/viewforum.php?f=98