>>When installing SQL Server, the default code page is ISO. However, I am wondering if one problem we have is related to that. What happen is any script created with Notepad is having all accented characters to be loss when opening the script in SQL Server.
>>
>>Will redoing the master database with a 850 code page solve the problem?
>
>Michel,
>
> This is a quote from the Microsoft Student Workbook for the SQL Server Administration course: "If you need to change the character set after you have installed SQL Server, you must rebuild the master database and user databases." There are other forbidding references in the Administrator's Companion that make me think this is not something you really want to do.

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.