Link to home
Start Free TrialLog in
Avatar of rwheeler23
rwheeler23Flag for United States of America

asked on

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?
ASKER CERTIFIED SOLUTION
Avatar of Norman Maina
Norman Maina
Flag of Kenya image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of rwheeler23

ASKER

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.
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.