Alter Sql-Login Default Language

• sqlcool

  SSC Eights!

  Points: 967

  More actions

  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

• jncarter

  Ten Centuries

  Points: 1195

  More actions

  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

• eddie.kumar

  Grasshopper

  Points: 23

  More actions

  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..