Restoring database with different sorting order

I am trying to restore a database (SQL server 7) with
sort ID 183 on a SQL server 7 with sort order ID 52.
I got this error message:
Microsoft SQL-DMO (ODBC SQLState: 42000):
The database you are attempting to restore was backed up
under different sort order ID(183) than the one currently
running on this server (52), and at least one of them is
a non-binary sort order.
Backup or restore operation terminating abnormally.
Any help please to restore this database on my server.
thanks
Database developerI'm afriad there is no way to restore different sort orders in SQL 7.
You could use DTS to transfer all objects over.
HTH
Ryan Waight, MCDBA, MCSE
"Database Developer" <database_udvikler@.hotmail.com> wrote in message
news:0c8301c38f0e$2d3ef280$a101280a@.phx.gbl...
> I am trying to restore a database (SQL server 7) with
> sort ID 183 on a SQL server 7 with sort order ID 52.
> I got this error message:
> Microsoft SQL-DMO (ODBC SQLState: 42000):
> The database you are attempting to restore was backed up
> under different sort order ID(183) than the one currently
> running on this server (52), and at least one of them is
> a non-binary sort order.
> Backup or restore operation terminating abnormally.
>
> Any help please to restore this database on my server.
> thanks
> Database developer|||Thank you Ryan for your quick reply.
Greetings
Database developer
>--Original Message--
>I'm afriad there is no way to restore different sort
orders in SQL 7.
>You could use DTS to transfer all objects over.
>
>--
>HTH
>Ryan Waight, MCDBA, MCSE
>"Database Developer" <> wrote in message
>news:0c8301c38f0e$2d3ef280$a101280a@.phx.gbl...
>> I am trying to restore a database (SQL server 7) with
>> sort ID 183 on a SQL server 7 with sort order ID 52.
>> I got this error message:
>> Microsoft SQL-DMO (ODBC SQLState: 42000):
>> The database you are attempting to restore was backed
up
>> under different sort order ID(183) than the one
currently
>> running on this server (52), and at least one of them
is
>> a non-binary sort order.
>> Backup or restore operation terminating abnormally.
>>
>> Any help please to restore this database on my server.
>> thanks
>
>.
>