different sort order id

When I am trying to restore a database, getting an error
message which says "database attempting to restore was
backed up under different sort order id than the one
currently running and atleast one of them is a non-binary
sort order. Operation terminating abnormally."
How I can I rectify this problem ?I'm guessing this is happening under SQL 7.0. On SQL 7.0 you can only
restore backups that contain the same sort order as the server in which you
are trying to restore to. Basically SQL 7.0 supports only a single sort
order for the server. But SQL 2000 does not have this limitation. In SQL
2000 you have server, database even column level sort orders, so you should
be able to restore your database backup to a 2000 server.
You might consider using DTS to move the data from the source server to your
new target server that has a different sort order then your source server.
----
----
--
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"Jagdish" <jnasit_x@.hss.hns.com> wrote in message
news:692701c42ea5$8b364e10$a101280a@.phx.gbl...
> When I am trying to restore a database, getting an error
> message which says "database attempting to restore was
> backed up under different sort order id than the one
> currently running and atleast one of them is a non-binary
> sort order. Operation terminating abnormally."
> How I can I rectify this problem ?
>