Thursday, October 2, 2014

0 SSMS 2008R2 IntelliSense may stop working after installing Visual Studio 2010 SP1

This is bug documented in http://support.microsoft.com/kb/2531482. To fix the issue, we need to upgrade the SSMS to at least CU7.

Unlike SQL Server 2012 onward, there is separate binary for SSMS, SSMS 2008R2 is part of SQL server binary distribution. Therefore, what we need is the latest CU/SP for the core database engine.

As this post, the latest SQL Server 2008R2 service pack is SP3 release on 9/26/2014. This can be download from here.

RTM version of SSMS 2008R2

image

image

image

image

After the upgrade

image

0 comments:

Post a Comment

 

SQL Panda Copyright © 2011 - |- Template created by O Pregador - |- Powered by Blogger Templates