SQL 2008 R2 and SQL 2008

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?
LVL 1
rwheeler23Asked:
Who is Participating?
 
Norman MainaCommented:
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
 
rwheeler23Author Commented:
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
 
rwheeler23Author Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.