Please help!! I am getting the following message when
attempting to restore one SQL7 db on to a new SERVER. The
installation calls for CASE Sensitive which I have set
upon installation but I am still receiving the following
error message:

ODBC SQLSTATE 42000

The database your are attempting to restore was backed up
under a different Unicode Locale ID (33280)or Unicode
Comparison Style (0)than the Unicode Locale ID (1033)or
the Unicode Comparison Style (196608)currently running on
this server. Backup or Restore Terminiated.

Hi,

Have come across this problem before.

You need to check and make sure both servers have been
installed using the same language and sort orderid.

You can check this by running sp_configure.

If you find they are different you will need to re-install
the server and make it the same as the originating server.
This you can do by running rebuild.exe in the mssql bin
directory.

This is a problem pre SQL Server 2000, however now in 2000
you are able to restore DB's with different server
collations etc.

Hope this helps.

Regards
Sanj