SQL 2008 : Intellisense (enabling & refreshing)

Enabling intellisense...

And once you have Intellisense, remember...

CTRL - SHIFT - R !!!

(that's the command to refresh the intellisense cache with new tables. objects etc)

links :
http://sqlblog.com/blogs/aaron_bertrand/archive/2009/07/01/why-is-intellisense-not-working.aspx
http://blogs.msdn.com/dtjones/archive/2008/09/11/refreshing-the-intellisense-cache.aspx