Hi!

You cannot change the server codepage. Our guys managed to do it once with some hacking or something like that, but than it is not available second time. Strange. Try to post this at MS site or at the www.tek-tips.com in the SQL forum. However, here we did not solved this problem despite our best effort of our SQL team, only solution we know is create script, copy data by BCP, than do backward operation after reinstall of the server with another codepage.

I like the idea with replication, however I do not know if this will work - had no chanse to try it...

>>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!
>>
>
>Thank you, Vlad
>
>If this is a big problem, then let's try a different approach: I can change the server's codepage? Maybe I'll attach it in this way.
>
>Thank you