Solved

SQL 2008 R2 and SQL 2008

Posted on 2011-02-14
3
378 Views
Last Modified: 2012-05-11
I recenlty upgraded one of my servers to SQL Server 2008 R2. On my other servers is 32 bit SQL Server 2008. If I go into a database and right click on any table and select Edit Top 200 rows I get a message "Cannot load file or assembly Microsoft.SqlServer.sqm, version = 10.0.0...."

Once I click OK I do see the data but is this warning something I ahve to live with now that I have a 32 bit  SQL lookikng at a 64 bit SQL or is there a way to correct this?
0
Comment
Question by:rwheeler23
  • 2
3 Comments
 
LVL 12

Accepted Solution

by:
NormanMaina earned 500 total points
ID: 34890113
the reason it complains is because the file Microsoft.SqlServer.Sqm.dll should be located in two folders.
the first one is: "C:\Program Files (x86)\Microsoft SQL Server\100\Shared" and the second one is "C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE"

manualy copying the file over to the IDE folder will fix the problem.

his file appears to have something to do with the customer experience improvment program.
0
 

Author Comment

by:rwheeler23
ID: 34891567
This is a 32 bit server so it was just C:\Program Files\Microsoft SQL Server\100\Shared.

But performing the copy worked just the same.

Thank you.
0
 

Author Closing Comment

by:rwheeler23
ID: 34891570
This is a 32 bit server so it was just C:\Program Files\Microsoft SQL Server\100\Shared.

But performing the copy worked just the same.

Thank you.
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Join & Write a Comment

I have written a PowerShell script to "walk" the security structure of each SQL instance to find:         Each Login (Windows or SQL)             * Its Server Roles             * Every database to which the login is mapped             * The associated "Database User" for this …
Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now