The intellisense shipped with sql2k8 SSMS is something very helpful. There is a way to refresh the local Intellisense cache to reflect the latest changes. Go to Edit --> IntelliSense --> Refresh Local Cache.
Rajan John is a database administrator with experience of more than 7 years mostly in SQL Server, Oracle, MySQL and Teradata. His areas of interests are data services across platforms, from data architecting, designing, developing to administering and analysis