>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.
Ah, you're right. The client access I am using right now still has SQL Server 2005. But, on mine, I have SQL Server 2008 and now I remember having seen that.