June 8, 2004 at 5:36 am
I am upgrading from sql7 to sql2000 in UK and noticed that the regional settings are English(US). I would like to use to English(UK).
What considerations do I need to take account of?
Will this change at operating system level have an effect on my upgraded sql2000 databases?
Thanks
June 9, 2004 at 3:20 pm
did this couple of years ago (EN-Canada to EN-US). If I remember correctly, make sure regional settings of your operating system match SQL collation settings (otherwise full-text won't work). This is all I remember.
June 10, 2004 at 2:11 am
Thanks Slolic.
In test I have moved user dbs using restore and have noticed that the collation on these is different to the collation on the system databases. Anyone have experince of problems from this? Im considering rebuildm.exe to change the collation of the system databases.
June 10, 2004 at 2:57 am
what about simply uninstall SQL Server .. then adjust your Control Pannel .. then Install it again.
it is only an idea
Alamir Mohamed
Alamir_mohamed@yahoo.com
June 15, 2004 at 12:53 am
Every time I install a SQL Server I have the same problem as you, except I want English (AUST). This is what I know:
When you install SQL Server it automatically looks at the regional settings in the OS and uses these. Because you want UK settings and not US you should change your OS Regional Settings through the Control Panel BEFORE you install SQL Server. Because you have already installed, you could try changing them and rebuilding master.
Collations and Code Pages can be changed during the installation of SQL Server by choosing "custom" installation. You will then get an option to choose which settings to use. All system databases will use the collations specified here.
If it is not too much trouble I would uninstall, change your regional settings, and then install SQL Server again specifying which collation to use. You can try rebuilding master db but I have had trouble with this in the past.
Cheers,
Angela
June 15, 2004 at 4:49 am
Thank you all for your help.
I resolved the issue by running rebuildm.exe
System and user databases both share same collation now.
I didnt realise that the user databases would be lost....but you live and learn.
Regards
June 15, 2004 at 5:17 am
you have to attach your user DB again (it is found as it is in your HDD) ..
Alamir Mohamed
Alamir_mohamed@yahoo.com
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply