Are there any free, or cheap plug-ins/add-ons for SQL Management Studio that provide intellisense and (less importantly) some auto-formatting? I've recently tried Redgate's product and really like it for these features, but I'm wondering if there are any alternatives.
I think ssms toolspack is what you are looking for. I use it myself. Works from sql-server 2005+