title | description | author | ms.author | ms.reviewer | ms.date | ms.service | ms.subservice | ms.topic | f1_keywords | helpviewer_keywords | dev_langs | ||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
sp_defaultlanguage (Transact-SQL) |
sp_defaultlanguage changes the default language of for a SQL Server login. |
markingmyname |
maghan |
randolphwest |
07/04/2024 |
sql |
system-objects |
reference |
|
|
|
[!INCLUDE SQL Server]
Changes the default language of for a [!INCLUDE ssNoVersion] login.
Important
[!INCLUDE ssNoteDepFutureAvoid] Use ALTER LOGIN instead.
:::image type="icon" source="../../includes/media/topic-link-icon.svg" border="false"::: Transact-SQL syntax conventions
sp_defaultlanguage
[ @loginame = ] N'loginame'
[ , [ @language = ] N'language' ]
[ ; ]
The login name. @loginame is sysname, with no default. @loginame can be an existing [!INCLUDE ssNoVersion] login, or a Windows user or group.
The default language of the login. @language is sysname, with a default of NULL
. @language must be a valid language on the server. If @language isn't specified, @language is set to the server default language (defined by the default language server configuration option).
Changing the server default language doesn't change the default language for existing logins.
0
(success) or 1
(failure).
sp_defaultlanguage
calls ALTER LOGIN
, which supports extra options. For information about changing other login defaults, see ALTER LOGIN.
Use the SET LANGUAGE
statement to change the language of the current session. Use the @@LANGUAGE
function to show the current language setting.
If the default language of a login is dropped from the server, the login acquires the default language of the server. sp_defaultlanguage
can't be executed within a user-defined transaction.
Information about languages installed on the server is visible in the sys.syslanguages
catalog view.
Requires ALTER ANY LOGIN
permission.
The following example uses ALTER LOGIN
to change the default language for login Fathima
to Arabic. This is the preferred method.
ALTER LOGIN Fathima WITH DEFAULT_LANGUAGE = Arabic;
GO