SQL Prompt by
redgate software fits the bill if you are looking for a T-SQL editor that can do intellisense.
I have been playing it for the past few hours and it does the job quite well. Best
part is its free.. well atleast for the time being..
Check it out here.
http://http://www.red-gate.com/products/SQL_Prompt/index.htm