Looks like there is an issue with intelliSense working with Sql Server Mgt Studio 2008 R2 after installing VS2010 SP1. This bug has been logged in Connect
and a forum started here
. Seems like installing the CU6
patch works for some, but is not a fix for all. I will follow up once I learn more.