>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.

-Mike