Can't restore

I want to restore database for my back. But it can't to
restore message from server is
Microsoft SQL-DMO (ODBC SQLState: 42000)
The database you are attempting to restore was backed up
under a different Unicode local ID(1054) or Unicode
comparison style (131073) than the Unicode local ID (1054)
or Unicode comparison style (196609) currently running on
this server. Backup or restore operation terminating
abnormally.
Please help me.
Big ThankYou are trynig to restore a database from a server which has a different
sort order to the one you are restoring onto.
You can
1. Use DTS to transfer the data (Or BCP out and script)
2. Rebuild master (Rebuildm)
3. Renistall SQL Server
use
Exec sp_helpsort
to find out the versions on each server
--
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"Seksan" <cscvpsek@.stou.ac.th> wrote in message
news:053801c35a78$8ba4baf0$a601280a@.phx.gbl...
> I want to restore database for my back. But it can't to
> restore message from server is
> Microsoft SQL-DMO (ODBC SQLState: 42000)
> The database you are attempting to restore was backed up
> under a different Unicode local ID(1054) or Unicode
> comparison style (131073) than the Unicode local ID (1054)
> or Unicode comparison style (196609) currently running on
> this server. Backup or restore operation terminating
> abnormally.
> Please help me.
> Big Thank