Post reply

Changing DATEFORMAT to British - dmy

  • October 14, 2010 at 7:28 am

    #141008

    Hi,

    Can anyone suggest how can I change my default regional language to British English?

    I am using this code on 'master' to change from US to British, but getting this error: "Could not find stored procedure 'sp_addlanguage'."

    Any help will be much appreciated, thank you

    exec sp_addlanguage 'British', 'English',

    'January,February,March,April,May,June,July,August,September,October,November,December',

    'Jan,Feb,Mar,Apr,May,Jun,Jul,Aug,Sep,Oct,Nov,Dec',

    'Monday,Tuesday,Wednesday,Thursday,Friday,Saturday,Sunday',

    dmy,1

    sp_configure 'default language', 1

    reconfigure with override

  • October 14, 2010 at 8:14 am

    #1236872

    Hi guys,

    silly me, I am using Express, so there is no sp_addlanguage sproc. so instead i used:

    EXEC sp_configure 'default language', '23' -- british_english ?

    GO

    RECONFIGURE;

    It helped, you only need to change for each login in Management Studio-Security-Logins

  • October 14, 2010 at 9:27 am

    #1236951

    Actually it has nothing to do with the edition that you work with. This procedure was needed in older version of SQL Server. If I’m not mistaken it was dropped since SQL Server 7, so it has to do with the SQL Server’s version and not the edition.

    Adi

    --------------------------------------------------------------
    To know how to ask questions and increase the chances of getting asnwers:
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

  • October 14, 2010 at 10:37 am

    #1237036

    Thanks for your reply, you are absolutely right. Because I wanted to change on a server side 'live' instance and couldn't do it with the either syntaxes. It runs, but then it asks to install it, (which did on my local express version). And when I run 'reconfigure' only it installed on express, but can't do it on live version (I presume it is older version)?

    The message i am getting is:

    "Address Windowing Extensions (AWE) is not supported in this edition of SQL Server."

    Any idea please?

  • October 14, 2010 at 10:41 am

    #1237042

    I thought it used the windows regional settings for that?

    Or maybe that was just excel..

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply