I installed Visual Studio 2010, which installed Express 2005.
I then tried to upgrade express to 2008 r2, in order to mount a newer mdf file. This was a challenge, and what I perhaps should have done was uninstall express 2005 and install the packaged version of 200 R2 SP1 with tools.
Eventually I got the upgrade to work, and then I installed SSMS.
Unfortunately, when I hit the New Query button, or right click on Select top 1000 rows I get the exception below.
After the usual searching blogs etc I tried to uninstall SQL as much as possible, then reinstalled the single exe for 2008 R2 SP1 with tools. This all seemed to succeed, but when I finally ran the "new" SSMS I still get the same problem.
Interestingly, if I run Edit top 200 rows this works!
I have an AMD core, 64 bits Windows7 Home Premium, and Visual Studio 2010 Universal.
I've found this error reported sporadically over the past couple of yea ...
Go to the complete details ...