>>This is what I did. We have scripts which rebuild all the tables. Then, we restore the backup. I wish we would be in Visual FoxPro. IAC, it doesn't change anything. We still have the problem with accented characters when opening a script created with Notepad.
>
>How did you get the backup restored? SQL Server won't restore a backup that was made on a server with differenct character set/sort order.

I will recheck the procedures we have done. I am wondering if they did change the code page in fact.