I'm from Croatia, and I need to change the default sql server (v.7) code page to 1250. Dont tell me to reinstall sql, because the instalation does not ask me what code page or language I want to use. Actually, I dont use the full SQL Server, but MSDE (Microsoft data engine), that provides a small sql server engine - but that's not important, I have all tools and functionality like real SQL server.
By default, the code page is set to ISO-8859-1, and that is for western europe. That information I have readed from table sysconfigures in master database. There is a field for "default sortorder id", and the value is linked to table syscharsets where all charsets are listed. There is also listed the charset for Croatia, that I need, and is described as "Croatian dictionary case-insensitive sort order for use with code page 1250" and his id is 92. His csid is 4, and that means that is linked to id 4 entry where is the "code page 1250". That is all fine, and as if I understud, the only thing that I need to do is change the value "52" in sysconfigures table to "92", and I will have the correct display of my characters in all sql databases.
But, I can't change the value in sysconfigres table !! When I try to, I get an error saying that I can't change that value.
I've been diging in sql server help, and I've found out that I need to execute the sp_configure stored procedure and some "recofigure" command... But I really don't know how to do all that!!!
So, SQL gurus, please help me to set my code page !!!