>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.
Bob
Bob Tracy
Never engage in a battle of wits if you're only half armed.