Post reply

Changing Regional Settings...what effect on sql2000?

  • June 8, 2004 at 5:36 am

    #66810

    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

    #509746

    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

    #509778

    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

    #509790

    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

    #510389

    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

    #510420

    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

    #510426

    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