SQL Prompt alternatives for SQL Server 2005?

Question

I'm trying to wean myself from SQL Prompt from Redgate because I'm now on a low low budget and I can't afford to go from 4 to 5. I haven't found anything nearly as good for SQL Server 2005.

Should I just save up, or has someone found a better tool or a way to exist without the intellisense features??

Answer 1

You can try out free SSMS and VS add-in, ApexSQL Complete

ApexSQL Complete provides snippets and syntax checking and a lot of code auto-complete features (context based predicting keywords, users, objects, autocompleting aliases, the Insert procedure parameters automatically option , the Insert full INSERT statement option and so on)

For code refactoring you could use ApexSQL Refactor, also a free add-in

Disclaimer: I work for ApexSQL as a Support Engineer