var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: SQLServer restore error due to unicode
I am trying to restore a SQL 7 database from one machine to another however I receive the a message similar to the following error message :-
The database you are attempting to restore was backed up under a different Unicode locale ID or Unicode comparison style
I have attached a screen shots
Anyone know how I can work around this ???
The db data in the backup is sorted in a different way than the new db is.
Run sp_helpsort on both machines to see what differs. They must look the same. Use the exe rebuild_m to change sortorder in the new db to match the other.