default language Option
Collapse the table of content
Expand the table of content

default language Option

SQL Server 2008 R2

Use the default language option to specify the default language for all newly created logins. To set default language, specify the langid value of the language you want, as listed in the syslanguages table. For more information, see sys.syslanguages (Transact-SQL).

The default language for a login can be overridden by using sp_addlogin or sp_defaultlanguage. The default language for a session is the language for that session's login, unless overridden on a per-session basis by using the Open Database Connectivity (ODBC) or OLE DB APIs. Note that you can only set the default language option to a language ID defined in syslanguages (0-32).


The language for a session can be changed during the session through the SET LANGUAGE statement. For more information, see SET LANGUAGE (Transact-SQL).

Community Additions

© 2016 Microsoft