Hi can anyone help ? I am new to SQL.
I am trying to restore a datafile backed up from a SQL 6 server at another
site to a new installation of sql 6.5 running as part of Small Business
Server.
When I try the restore I get the following message
The database you are attempting to Load was dumped under a different sort
order id (32) than the one currently running on this server (52) and at
least one of them is a non binary sort order.
I have tried re-indexing the master datafile from setup but the list of
available sort orders just says Dictionary order case-insensitive. Since
according to the book I am reading the sort order ID 32 and sort order id
52 are both dictionary order case-insensitive I assume that it is a
difference between versions.
Any help as to where I proceed from here would be most appreciated !!