How to change default language for SQL Server?

by

Using SQL Server Management Studio

To configure the default language option

  1. In Object Explorer, right-click a server and select Properties.
  2. Click the Misc server settings node.
  3. In the Default language for users box, choose the language in which Microsoft SQL Server should display system messages.
    The default language is English.

Using Transact-SQL

To configure the default language option

  1. Connect to the Database Engine.
  2. From the Standard bar, click New Query.
  3. Copy and paste the following example into the query window and click Execute.

This example shows how to use sp_configure to configure the default language option to French 

USE AdventureWorks2012 ;
GO
EXEC sp_configure 'default language', 2 ;
GO
RECONFIGURE ;
GO

The 33 languages of SQL Server

| LANGID |        ALIAS        |
|--------|---------------------|
|    0   | English             |
|    1   | German              |
|    2   | French              |
|    3   | Japanese            |
|    4   | Danish              |
|    5   | Spanish             |
|    6   | Italian             |
|    7   | Dutch               |
|    8   | Norwegian           |
|    9   | Portuguese          |
|   10   | Finnish             |
|   11   | Swedish             |
|   12   | Czech               |
|   13   | Hungarian           |
|   14   | Polish              |
|   15   | Romanian            |
|   16   | Croatian            |
|   17   | Slovak              |
|   18   | Slovenian           |
|   19   | Greek               |
|   20   | Bulgarian           |
|   21   | Russian             |
|   22   | Turkish             |
|   23   | British English     |
|   24   | Estonian            |
|   25   | Latvian             |
|   26   | Lithuanian          |
|   27   | Brazilian           |
|   28   | Traditional Chinese |
|   29   | Korean              |
|   30   | Simplified Chinese  |
|   31   | Arabic              |
|   32   | Thai                |
|   33   | Bokmål              |

More Related Contents:

  1. Max Nbr of Months W/ No Activity in Past 12 Months
  2. SQL server query to output the data shown below
  3. Will ANSI JOIN vs. non-ANSI JOIN queries perform differently?
  4. Find a value anywhere in a database
  5. Function to Calculate Median in SQL Server
  6. How do I generate a random number for each row in a T-SQL select?
  7. How to check if a column exists in a SQL Server table
  8. Combine multiple results in a subquery into a single comma-separated value
  9. How do you view ALL text from an ntext or nvarchar(max) in SSMS?
  10. Floor a date in SQL server
  11. How to drop a table if it exists?
  12. Create a view with ORDER BY clause
  13. What does ‘COLLATE SQL_Latin1_General_CP1_CI_AS’ do?
  14. INSERT INTO vs SELECT INTO
  15. Possible to store value of one select column and use it for the next one?
  16. How FOR XML PATH(”) works when concatenating rows
  17. Date conversion and culture: Difference between DATE and DATETIME
  18. Scheduled run of stored procedure on SQL server
  19. SQL Server ORDER BY date and nulls last
  20. How to remove accents and all chars a..z in sql-server?
  21. SQL Server variable columns name?
  22. What is the Oracle equivalent of SQL Server’s IsNull() function?
  23. SQL Recursive CTE: Finding objects linked by property
  24. Use of Begin / End Blocks and the Go keyword in SQL Server?
  25. PRINT statement in T-SQL
  26. Ampersand (&) operator in a SQL Server WHERE Clause
  27. T-sql – determine if value is integer
  28. Convert decimal time to hours and minutes
  29. how to write number to word function in sql server [closed]
  30. What are row, page and table locks? And when they are acquired?

Leave a Comment