default language Option
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).
Note
The language for a session can be changed during the session through the SET LANGUAGE statement. For more information, see SET LANGUAGE (Transact-SQL).
See Also