sp_addlanguage

Defines the names of the months and days for an alternate language and its date format.

Syntax

sp_addlanguage language, alias, months, shortmons, 
	days, datefmt, datefirst

Parameters

Examples

Usage

Usually, you add alternate languages from one of SAP ASE’s Language Modules using the langinstall utility or the SAP ASE installation program. A Language Module supplies the names of the dates and translated error messages for that language. However, if a Language Module is not provided with your server, use sp_addlanguage to define the date names and format.

Use alter login to change a user’s default language. If you set a user’s default language to a language added with sp_addlanguage, and there are no localization files for the language, the users receive an informational message when they log in, indicating that their client software could not open the localization files.

See also:
  • set in Reference Manual: Commands

  • langinstall in the Utility Guide

Permissions

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

SettingDescription
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:

InformationValues
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

Related reference
sp_droplanguage
sp_helplanguage
sp_modifylogin
sp_setlangalias