Post reply

Setting the Default Language on SQL Server 2005

  • June 15, 2006 at 8:25 am

    #172789

    i posted this on the general 2005 forum, but thought I would post it here too:

    Hi. I'm trying to change the default language used for my server to be from US English to British English. I'm using this:

    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

    However it errors complaining that it can't find sp_addlanguage.

    I tried to look for it and couldn't find it either, so am wondering if the name has changed in 2005?

    If I right click the server and choose properties, I can see the language being used, but can't edit it from there.

    Any insight here is welcome!

    Thanks in advance,

    David

  • June 15, 2006 at 11:11 am

    #644035

    Looking 'sp_addlanguage' up in SQL 2005 Books Online I couldn't find a reference to it, however in 2000 Books Online (locally) it says that for SQL Server 2000 it was "Removed; no longer available. Remove all references to sp_addlanguage."

    Therefore I would presume it was not reintroduced in 2005.

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

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