What are some good, reasonably-priced SQL Server client tools offering Intellisense for SQL?

Question

SSMS 2008 doesn't have SQL Intellisense when connected to SQL Server 2005! I know of 3 products which enable writing SQL with Intellisense. ApexSQL Edit, Red Gate's SQL Prompt Pro & SQL Assistant. However I am looking for a less expensive solution.

Any ideas?

Answer 1

Those are pretty much the three choices.

Answer 2

If you don't want to pay for an add-in, you could always roll your own (although in the long run it may be cheaper to just pay for an existing solution). Jon Sayce has a good blog post on Building a SSMS Add-In if you want to give it a shot.

Answer 3

Embrace Linq and use LinqPad.

Full intellisense using linq on sql servers, fully integrated with c# statements or expressions, for $27.