Assigns or changes the alias for an alternate language.
sp_setlangalias language, alias
is the official language name of the alternate language.
is the new local alias for the alternate language.
sp_setlangalias french, français
This command assigns the alias name “français” for the official language name “french”.
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.
The permission checks for sp_setlangalias differ based on your granular permissions settings.
Granular permissions enabled |
With granular permissions enabled, you must be a user with manage server privilege. |
Granular permissions disabled |
With granular permissions disabled, you must be a user with sa_role. |
Values in event and extrainfo columns from the sysaudits table are:
Event |
Audit option |
Command or access audited |
Information in extrainfo |
|---|---|---|---|
38 |
exec_procedure |
Execution of a procedure |
|
Commands set
System procedures sp_addlanguage, sp_droplanguage, sp_helplanguage
