Home > SQL Server > SQL Server 2008 R2 – Intellisense not working – Visual Studio 2010 SP 1

SQL Server 2008 R2 – Intellisense not working – Visual Studio 2010 SP 1

Hi,

Recently intellisense in the SQL Server management Studio stopped working.

It appears that it was caused by the installation of Visual Studio 2010 SP1.

The issue was raised here:
https://connect.microsoft.com/SQLServer/feedback/details/650569/ssms-2008-r2-is-losing-intellisense-after-installing-visual-studio-2010-sp1

It was originally suggested that this could fixed by SQL Server 2008 R2 Cumulative Update #6, but this in turn lead to a crash in Visual Studio 2010 when ever you opened a .sql file in your database projects.
https://connect.microsoft.com/VisualStudio/feedback/details/653180/method-not-found-opening-files-in-database-project

It suggested that this issue has been fixed and will be released in SQL Server 2008 R2 Cumulative Update #7, which was due out in Mid April.

You can install Cumulative Update #6 and in most cases this will get intellisense working in SSMS but it will break Intellisense (on database projects) in VS2010.

So if you are like me, you are between a rock and a hard place, your choice of which environment you prefer to have working.

Lets hope that CU #7 fixes it.

I will update this post with my results after I have applied CU #7.

Cheers…

Update as @ 19th April

Today Microsoft has released Cumulative Update package 7 for SQL Server 2008 R2

After downloading and installing, preliminary results are that the problem is solved.

Intellisense in SSMS seems to be working and I no longer get the crashes in Visual Studio 2010 and Intellisense in Visual Studio 2010 database projects also seem to be working correctly. So, so far so good.

Advertisements
Categories: SQL Server
  1. JD
    14 April, 2011 at 5:36 pm

    Still waiting u to CU #7 results…

  2. Pin0
    24 April, 2011 at 5:42 pm

    Don’t work !

    • jcrawfor74
      27 April, 2011 at 4:58 pm

      The above note as @ 19th April was tested on a 32-bit windows 7 box with SQL Express 2008 R2 (Advanced Install). It upgraded fine.

      I went to work and tried it out and no luck. Work is a 64-bit Windows Server 2008 R2 box. I applied the 32-bit update. No luck.

      I tried to apply the 64-bit update but the package complained about being the first in a set. I applied the 64-bit update today after waiting for microsoft to fix it. Still no luck.

      I re-applied VS 2010 SP1 and rebooted and Intellisense in SQL Server is now working again, but the VS 2010 appears not to be working still.

  3. wrack
    13 May, 2011 at 1:10 pm

    I went to this page to get the hotfix.

    http://support.microsoft.com/hotfix/KBHotfix.aspx?kbnum=2507770&kbln=en-us

    It shows 6 of them, which one should I install?

    • jcrawfor74
      21 May, 2011 at 7:52 pm

      I used the following:
      Windows 32 bit – SQLServer2008R2_RTM_CU7_2507770_10_50_1777_x86
      Windows 64 bit – SQLServer2008R2_RTM_CU7_2507770_10_50_1777_x64

      Cheers

  4. Jitendra
    20 May, 2011 at 4:10 pm

    I downloaded SQLServer2008R2_RTM_CU7_2507770_10_50_1777_x64.

    When extracting I tried with the 2 passwords given by hotfix. But it is not extracting. What is the problem please mail me

    • jcrawfor74
      20 May, 2011 at 10:35 pm

      I assume you are on a 64-bit server? I had issues with this download @ first complaining about it needing the first in the backup set, but after a week I tried downloading again and it worked fine. If you are on a 32 bit machine you should download “SQLServer2008R2_RTM_CU7_2507770_10_50_1777_x86”. Beyond that you may need to try it on another machine or follow it up with microsoft.

  5. subbiee
    28 August, 2011 at 11:49 pm
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: