Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

SQL 2008 R2 and SQL 2008

Posted on 2011-02-14
3
Medium Priority
?
394 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 2000 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

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Question has a verified solution.

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

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 …
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…

571 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