SQL Server - SQL Server configuration - code page?

Asked By Goran Matosevic on 20-Jul-14 12:50 AM
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 !!! 

CODE PAGE - Asked By Peter Bromberg on 20-Jul-14 12:50 AM

sp_configure 'default_language',16 -- (Croatian)
GO
RECONFIGURE
GO

Yes, but how? - Asked By Goran Matosevic on 20-Jul-14 12:51 AM

Yes, I found that piece of code in help...
But I dont know where to type it, and how to execute it.
Step by step info please, I'm new in sql server.

NOT WORKING ! - Asked By Goran Matosevic on 20-Jul-14 12:51 AM

Changing the default language have not helped me. I need to change the default sortorder, unicode comparsion and that stuff... After changing the def. language to croatian, my default sortorder and code page is still ISO-8859-2 for Western Europe. I need it to be 1250,Central European!
With sp_configure I can not do that, can I? So how to do it?
Any thoughts? - Asked By Robbe Morris on 17-Aug-01 02:13 PM
I think he forgot to email you.
OSQL!!!! - Asked By Peter Bromberg on 17-Aug-01 02:37 PM
1)Drop to DOS box.
2) OSQL -Uusername -Ppassword
3) USE MASTER <ENTER>
5) GO <ENTER>
6) sp_configure etc.etc.

Rest of info you need (since I see you found it) is in the help.
Done that, but the problem remains... - Asked By Goran Matosevic on 17-Aug-01 04:31 PM
Changing the default language have not helped me.  I need to change the default sortorder, unicode comparsion and that stuff...  After changing the def.  language to croatian, my default sortorder and code page is still ISO-8859-2 for Western Europe.  I need it to be 1250,Central European! 
With sp_configure I can not do that, can I? So how to do it? 

I did not find anything in help....