Configure Default Language on SQL Server

Article Content

Overview

SDS4 Distribution has quickly grown very popular around the world.
This article shows how to configure SQL Server to store and display data such as Date/Time Formats for countries outside the US

Getting Started

Open SSMS (SQL Server Management Studio)

  • In Object Explorer, right-click a server and select Properties
  • Click General settings
  • Located the Default language for users box
  • Enter the Language Code Using the list below

Language Code
English 1033
German 1031
French 1036
Japanese 1041
Danish 1030
Spanish 3082
Italian 1040
Dutch 1043
Norwegian 2068
Portuguese 2070
Finnish 1035
Swedish 1053
Czech 1029
Hungarian 1038
Polish 1045
Romanian 1048
Croatian 1050
Slovak 1051
Slovene 1060
Greek 1032
Bulgarian 1026
Russian 1049
Turkish 1055
British English 2057
Estonian 1061
Latvian 1062
Lithuanian 1063
Brazilian 1046
Traditional Chinese 1028
Korean 1042
Simplified Chinese 2052
Arabic 1025
Thai 1054

Was this helpful?