>>Just in case to you and Viv a heads up about SSMS intellisense
>>
>>http://social.msdn.microsoft.com/Forums/en-US/sqltools/thread/36e3d0db-3150-434a-885d-97810fe199c5
>
>I have never seen intellisense in SSMS. Where exactly is there an option that benefit from that in there?

In SSMS in 2008R2 Intellisense kicks in for database, table, and field names as you type, among other things. Very handy.

To get that before you had to use a tool by Red Gate or some other tool.