Post reply

Alter Sql-Login Default Language

  • May 4, 2010 at 10:58 pm

    #140065

    Hi there

    I use this statement to alter Sql-Login default language but getting this error

    ALTER LOGIN XXX WITH DEFAULT_LANGUAGE = 'British English'

    Error:

    Msg 102, Level 15, State 1, Line 1

    Incorrect syntax near 'DEFAULT_LANGUAGE'.

    is there any better way of doing this?

    Cheers

  • May 4, 2010 at 11:32 pm

    #1162240

    Your syntax is close but you don't need the single quotes.

    ALTER LOGIN xxx WITH DEFAULT_LANGUAGE = British

    -Jeremy

  • November 2, 2018 at 5:59 am

    #2012171

    jncarter - Tuesday, May 4, 2010 11:32 PM

    Your syntax is close but you don't need the single quotes.ALTER LOGIN xxx WITH DEFAULT_LANGUAGE = British-Jeremy

    Thanks Jez ... You are wealth of knowledge.. 🙂

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

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