I wish MS would just make the changes, why should we have to depend on 3rd party vendors?
Some of the most obvious ones that should have been in QA long ago and will be very disappointing if they are not in 2005:
Parenthesis () checker!!!!!! Please don't make me yet again check manually the ltrim(rtrim(str())) statement I just wronte. - As a side note, why the heck isn't there an alltrim() in T-SQL????
Intellisense/AutoComplete! Functions (substring, dateadd, etc) and procs should give you a tool tip to remind you of arguments as you type. Tables and view should have Intellisense so you can type "select authors. " and have a list of all the fields from the table authors.
Auto Correct! How many times have you typed "selcet col from table"?
Code Snippets! Something better then templetes. Also, when I type "case" or "if" the IDE should know what is coming next and create the outline of the construct.
Auto Formatting! Indent and format views, procs, and adhoc queries.