I wanted to get other's opinions as well as share my own.
I just came across a pretty good product from devArt called SQL Complete that is an add-in for SSMS and VS. It includes upgraded Intellisense (which allows you to replace the Intellisense included with SSMS) and T-SQL formatting tools. This is the first time I have used this product but in the past I have used Sql Prompt from RedGate, which I would consider a competitor. I love RedGate tools because they are solid and are very powerful. However, being on my own, they can be cost prohibitive so I went looking for less expensive alternatives, which is how I came across devArt SQL Complete.
From my testing it looks like both have the same basic functionality. However, I found 2 things that set the devArt product apart from the RedGate tool. First, SQL Complete allows for Intellisense similar to how it works in VS, in that Intellisense will display entries that "contain" the text being entered while Sql Prompt only displays entries that "start with" the text being entered. Second, the cost is a factor in that SQL Complete is $99 for the Standard edition or they offer a FREE edition, yes a FREE edition. devArt is kind enough to display a matrix comparing the 2 editions so you know exactly what is included in each. RedGate only offers 1 edition at $195 and a trial that lasts 14 days.
So, given that info, my preference is the devArt SQL Complete product. What is yours? Has anyone used either of these and maybe could provide some feedback?
<a href="http://www.devart.com/dbforge/sql/sqlcomplete/" target="_blank" >
<img alt="sqlcomplete" src="http://media.linkedin.com/media-proxy/ext?w=100&h=80&hash=G5etneXgiLriHtrNg9hsiBl7cOc%3D&url=http%3A%2F%2Fwww.devart.com%2Fimages%2Flogos%2Fdbforge-sql-complete-small.jpg">
dbForge SQL Complete - Powerful T-SQL Formatting Tool