Restoring is not working

[Basheer]

Hi All
i am having sql server 7.0,i back up my database using the backup option,but
when i try to restore it in another system its giving one error message "The
Database You Are Attempting To Restore Was Backed Up Under A Different Sort
Order ID(52) Than The One Currently Running On This Server(146) And At leatstOne
Of Them Is A Non Binary Sort Order"
How to fix this
pls help me
Basheer

[David Satz]

take a look at this:
http://www.sqlmag.com/forums/message...&threadid=9013

though it is a lousy solution...

"Basheer" <basheer_ad@hotmail.com> wrote in message
news:3e115a6d$1@tnews.web.devx.com...
>
> Hi All
> i am having sql server 7.0,i back up my database using the backup
option,but
> when i try to restore it in another system its giving one error message
"The
> Database You Are Attempting To Restore Was Backed Up Under A Different
Sort
> Order ID(52) Than The One Currently Running On This Server(146) And At
leatstOne
> Of Them Is A Non Binary Sort Order"
> How to fix this
> pls help me
> Basheer