Allow renaming of variables easily
In the T-SQL editor it'd be really good if you could rename variables easily. In VS, if you use Resharper clicking on a variable and hitting F2 allows you to rename that variable and all occurrences of it easily. It even searches strings and comments and offers these as an option
This is included in SQL Prompt 6.4, which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/
But SmarterSQL is a VERY long-dead, confessed to be buggy, incomplete tool for 2005 & 2008. May not be such a good idea. Be very careful...
Benjamin S commented
SmarterSql does this: http://smartersql.codeplex.com/