sys.syslanguages (Transact-SQL)

Contains one row for each language present in the instance of SQL Server.

Column name	Data type	Description
langid	smallint	Unique language ID.
dateformat	nchar(3)	Date order, for example, DMY.
datefirst	tinyint	First day of the week: 1 for Monday, 2 for Tuesday, and so on through 7 for Sunday.
upgrade	int	Reserved for system use.
name	sysname	Official language name, for example, Français.
alias	sysname	Alternative language name, for example, French.
months	nvarchar(372)	Comma-separated list of full-length month names in order from January through December, with each name having up to 20 characters.
shortmonths	nvarchar(132)	Comma-separated list of short-month names in order from January through December, with each name having up to 9 characters.
days	nvarchar(217)	Comma-separated list of day names in order from Monday through Sunday, with each name having up to 30 characters.
lcid	int	Microsoft Windows locale ID for the language.
msglangid	smallint	Database Engine message group ID.

The Database Engine contains the following installed languages.

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

See Also