SQL sort code ID

[Guest_imported]

We inherited old SQL data in the form of an old dump files and my boss decided he wants to retrieve this data for some unknown reason. The problem is none of us know anything about SQL. We have the SQL 6.0 installation disks a dump file with the member’s data and we want to install/retrieve this data on an NT server. After setting the server I attempted to retrieve the data I receive the NT error 3120 Dumped under a different sort code ID (54)
Can anyone tell me what to do?

 

[RickCole]

Unfortuantly you have to rebuild your master database or re-install SQL Server and select the correct Sort Order. This must match the database Sort Order when it was orgianly backed up.

Text from books online:

Message Text
The database you are attempting to LOAD was DUMPed under a different sort order ID (%d) than the one currently running on this server (%d), and at least one of them is a non-binary sort order.

Explanation
This error occurs when you try to load a database that has a different sort order from that of the dumped database. Data does not have to be sorted in binary order.
A database cannot be loaded into SQL Server using LOAD DATABASE unless the sort order on the SQL Server that dumped the database matches the sort order on the SQL Server being loaded into.
Action
You can either move the data (using bcp rather than LOAD), or you can change the sort order on the SQL Server.
You can use the setup program to update your existing installation and rebuild the master database, but you must still rebuild all other databases yourself. For additional information, see Microsoft SQL Server Setup and Chapter 3, "Configuring Servers."

Rick.

 

[Guest_imported]

Thanks RickCole for your input but I’ve attempted several rebuilds of the master database with no luck. The sort code ID 54 is required but alas I don’t know what set-up option to achieve this sort code e.g. is this a custom sort code if so how do I set-up the parameters.
Any help!!!

 

[RickCole]

Sort Order 54 equates to noaccent.iso. Long time since I have done a SQL 6.0 install but noaccent.iso should equate to one of the Sort Order options displayed within the master database set-up.

A couple of Knowledge base articles, which might also be useful, are [Q189331] and [Q95585].

Rick.

 

[Guest_imported]

Rickcole it worked perfectly
Thanks!!