sp_setlangalias System Stored Procedure

Assigns or changes the alias for an alternate language.

Syntax

sp_setlangalias language, alias

where

language
Is the name of the language.
alias
Is the new local alias for the alternate language.

Remarks

The alias replaces the current value of the syslanguages.alias for the original language.

The new alias can be used in place of the original language by the SET LANGUAGE statement.

Example

This example assigns the alias name français to the original language name French.

sp_setlangalias français, french

Permission

Execute permission defaults to the system administrator.

Table Used

master.dbo.syslanguages

See Also

SET sp_helplanguage
sp_droplanguage