SQL 2008 R2 and SQL 2008

Posted on 2011-02-14
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?
Question by:rwheeler23
  • 2
LVL 12

Accepted Solution

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.

Author Comment

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.

Author Closing Comment

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.

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Pivot not using aggregate yield error 3 41
How to SQL Trace a SPECIFIC query 24 57
Implementing SQL Server Data Files in Azure 1 35
Sql Query 4 0
After restoring a Microsoft SQL Server database (.bak) from backup or attaching .mdf file, you may run into "Error '15023' User or role already exists in the current database" when you use the "User Mapping" SQL Management Studio functionality to al…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Concerto provides fully managed cloud services and the expertise to provide an easy and reliable route to the cloud. Our best-in-class solutions help you address the toughest IT challenges, find new efficiencies and deliver the best application expe…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

914 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

20 Experts available now in Live!

Get 1:1 Help Now