December 2, 2001 at 3:20 am
During installation of SQL server 2000 on Windows 2000 Server a default code page of ISO-8859-1 had been used. As I know it is possible to change this code page by inserting proper key in the Windows registry of SQL server section. Maybe someone could help?
December 2, 2001 at 9:04 am
I found this key:
HKLM\Microsoft\MSSQLServer\MSSQLServer\DefaultCollationName
On my system is set to "SQL_Latin1_General_CP1_CI_AS". I tried changing it and creating a new db, got the same original collation. Stopped and started the service, same thing. SQL doesn't appear to read from that key in the process of creating the new db.
According to BOL, new db's are created using the collation of model - which makes sense. So if you want to change this, create a new db with the correct collation, then replace the model with it.
Anyone have an easier way?
Andy
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply