I'm running SQL 6.5 on an old NT4 server. I built a new W2K server with SQL 6.5.
When I tried to restore a database to the new server I got the following error: "The database you are attempting to LOAD was DUMPed under a different sort order ID (52) than the one currently running on this server (32), and at least one of them is a non-binary sort order."
Since SQL 6.5 is no longer supported by Microsoft, I have a hard time finding information related to that error. Can someone help me and tell me what's wrong?
It has been a LONG time since I've installed MS-SQL 6.5, but the sort order is specified somewhere very early in the installation process.
Have you considered using SQL 7.0 instead, and restoring the dump into a database there? It seems to me that you can restore a 6.5 dump onto a 7.0 server, and that they aren't nearly as finicky about sort orders.