Error in restoring database

Hi!
I would like to ask for help regarding the error message
that I always encounter when I'm trying to restore a
database:
ODBC SQLState: 42000
The database you are attempting to restore was backed up
under a diffferent sort order ID (205) 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 ideas on how to solve to problem?
Thanks!
Best Regards,
JunYes, restore to SQL 2000 instead of SQL 7. SQL 7 can only restore databases
in the same sort order as SQL was installed in (run sp_helpsort to figure
this out). SQL 2000 can handle multiple collations. You can then transfer
the SQL 2000 database elsewhere.
****************************************
***************************
Andy S.
MCSE NT/2000, MCDBA SQL 7/2000
andymcdba1@.NOMORESPAM.yahoo.com
Please remove NOMORESPAM before replying.
Always keep your antivirus and Microsoft software
up to date with the latest definitions and product updates.
Be suspicious of every email attachment, I will never send
or post anything other than the text of a http:// link nor
post the link directly to a file for downloading.
This posting is provided "as is" with no warranties
and confers no rights.
****************************************
***************************
"Jun" <junpena@.chinasystems.com> wrote in message
news:10d501c3c6da$0aad5e10$a501280a@.phx.gbl...

quote:

---

> Hi!
> I would like to ask for help regarding the error message
> that I always encounter when I'm trying to restore a
> database:
> ODBC SQLState: 42000
> The database you are attempting to restore was backed up
> under a diffferent sort order ID (205) 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 ideas on how to solve to problem?
> Thanks!
> Best Regards,
> Jun

---