SET LANGUAGE

Specifies the language environment for the session. The session language determines the datetime formats and system messages.

The only supported setting is us_english. Any other setting will throw an error.

Syntax

SET LANGUAGE { [ N ] 'language' | @language_var }  [;]

Arguments

[N]’language’ | @language_var

Is the name of the language as stored in sys.syslanguages. This argument can be either Unicode or DBCS converted to Unicode. To specify a language in Unicode, use N’language’. If specified as a variable, the variable must be sysname.

Remarks

Argument values are ignored and do not change the default behavior.

Permissions

Requires membership in the public role.

Examples

The following example sets the language us_english.

SET LANGUAGE us_english;

See Also