Do you guys know of any free tool that does a nice job with the intellisense for SQL Server 05?
SQLPrompt is just awesome, but they're not into giving their stuff for free :)
Do you guys know of any free tool that does a nice job with the intellisense for SQL Server 05?
SQLPrompt is just awesome, but they're not into giving their stuff for free :)
RedGate SQLPrompt actually was free until September 2006. I'm not sure what the legal status is, but if you could get a version pre-dating that you may be able to use it (depending on license etc). That's about the best I know, I'm afraid.
Here's a list asked by another SO user: http://stackoverflow.com/questions/391240/recommendations-for-sql-server-2005-intellisense-tools-add-ins/397726. No free ones, I'm afraid.
I am using the free version of EMS SQL Manager for SQL Server, which has code completion and syntax highlight.
Management studio that ships with SQL Server 2008 has it built in but it works only if you connect to a server that also runs 2008 (so client tools from 2008 is not enough)
Toad™ for SQL Server Freeware has intellisense, and may be used for a maximum of five (5) users within Licensee's organization.