Hi!

As far as I know, this is a big problem. I know only one way to transfer this - generate SQL script for database, then copy all data by using BCP, then re-create database structure using scrip on another server with another codepage, then copy data to new server by BCP utility. Tremendous.

Another idea I have to use replication for that, I know it iis possible to use it to copy the data from one serevr to another, but I did not tried it to copy data between servers with different codepages.

Good luck!

>Hello, All
>
>I'm not sure if this is the correct section, but it seems a recovery to me:
>
>I've created a database using MSDE. I didn't know at that time how to set the collating sequence and index order in osql.exe (this is the tool I've used) and now I have some errors about this. At that time, the local computer was running Romanian CodePage and now I have English codepage.
>
>I have some questions:
>
>1. How to attach a database to a SQL server, if the database was not detached from the MSDE? I have only the files .MDF and .LDF.
>2. How to retrieve the collating sequence and index order from a database and how to change them, supposing I cannot attach the database to a SQL Server?
>
>Please, help me, I'm in hurry. Tomorrow I must have the database attached.
>
>Thank you very much