locked
Set Local Language SQL Server RRS feed

  • Question

  • I am a bangladeshi . I want do work with bengali language at my SQL Server 2014 . So How Can Set My Local Language At My SQL Server 2014
    Tuesday, November 17, 2015 7:39 PM

Answers

  • To do so, open SQL Server Management Studio (SSMS) > Right click Server in Object Explorer > Properties > Advanced > Check the ‘Default Language’ property and make sure it is set to the one you want.

    Using TSQL:

    Look up the sys.messages catalog view to check if SQL Server supports a message in your local language.

    SELECT msg.language_id, lang.langid, alias 
    FROM
    sys.messages AS msg
    JOIN
    syslanguages AS lang
    ON lang.msglangid = msg.language_id
    GROUP BY  msg.language_id, lang.langid, alias

    then once you know the langid use below tsql

    EXEC sp_configure "default language", n  -- n = `langid` that you want to set
    RECONFIGURE WITH OVERRIDE;

    note: you have to restart SQL server and this is an instance wide setting.

    • Marked as answer by benjir01 Wednesday, November 18, 2015 2:20 AM
    Tuesday, November 17, 2015 7:59 PM
  • Bengali is not a listed language in SQL Server. You first need to make your OS settings changed to the desired language and then change SQL Server language.

    To change the operating system user interface setting
    In Control Panel, open Regional and Language Options.
    On Formats tab, select the desired specific
    Click Apply, OK
    Open SQL Server, Right click on Database Engine, Properties
    Select the desired language and click ok

    Thanks, AT

    • Marked as answer by benjir01 Wednesday, November 18, 2015 2:20 AM
    Tuesday, November 17, 2015 8:47 PM

All replies

  • To do so, open SQL Server Management Studio (SSMS) > Right click Server in Object Explorer > Properties > Advanced > Check the ‘Default Language’ property and make sure it is set to the one you want.

    Using TSQL:

    Look up the sys.messages catalog view to check if SQL Server supports a message in your local language.

    SELECT msg.language_id, lang.langid, alias 
    FROM
    sys.messages AS msg
    JOIN
    syslanguages AS lang
    ON lang.msglangid = msg.language_id
    GROUP BY  msg.language_id, lang.langid, alias

    then once you know the langid use below tsql

    EXEC sp_configure "default language", n  -- n = `langid` that you want to set
    RECONFIGURE WITH OVERRIDE;

    note: you have to restart SQL server and this is an instance wide setting.

    • Marked as answer by benjir01 Wednesday, November 18, 2015 2:20 AM
    Tuesday, November 17, 2015 7:59 PM
  • Bengali is not a listed language in SQL Server. You first need to make your OS settings changed to the desired language and then change SQL Server language.

    To change the operating system user interface setting
    In Control Panel, open Regional and Language Options.
    On Formats tab, select the desired specific
    Click Apply, OK
    Open SQL Server, Right click on Database Engine, Properties
    Select the desired language and click ok

    Thanks, AT

    • Marked as answer by benjir01 Wednesday, November 18, 2015 2:20 AM
    Tuesday, November 17, 2015 8:47 PM
  • After Change My OS Language  Have To My Own Language Without Problem ? After Change My Language  FOR Design Query by Own Language That Time   Any Problem  Example  SELECT আইডি,নাম,ঠিকানা, FROM Table_1 WHERE আইডি ='"& TextBox1.Text &"' .Like This Query Is It Possible After Change SQL Server Language And My OS Language.
    Wednesday, November 18, 2015 2:42 AM
  • Sir I Changed My OS Language Now I Have To  Change My SQL Server Language .Please Share Video  A Link  . How To Change My SQL Server Language   
    Friday, November 20, 2015 4:34 PM
  • I Changed My OS Language . But Current OS Language Do Not Show SQL Server Default Language . Show How Can Set That Sql Server . Please Help  
    Saturday, November 21, 2015 2:56 AM