sp_setlangalias

Syntax

sp_setlangalias language, alias

Parameters

language – is the official language name of the alternate language.
alias – is the new local alias for the alternate language.

Examples

Example 1 – Assigns the alias name “français” for the official language name “french”:
```
sp_setlangalias french, français
```

Usage

alias replaces the current value of syslanguages.alias for the official name; the set language command can use the new alias in place of the official language name.

See also set in Reference Manual: Commands.

Permissions

The permission checks for sp_setlangalias differ based on your granular permissions settings.

Setting	Description
Enabled	With granular permissions enabled, you must be a user with `manage server` privilege.
Disabled	With granular permissions disabled, you must be a user with sa_role.

Auditing

Values in event and extrainfo columns from the sysaudits table are:

Information	Values
Event	38
Audit option	exec_procedure
Command or access audited	Execution of a procedure
Information in `extrainfo`	Roles – Current active roles Keywords or options – NULL Previous value – NULL Current value – NULL Other information – All input parameters Proxy information – Original login name, if set proxy in effect