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 desired language, as listed in the syslanguages table. For more information, see syslanguages.

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 using the ODBC or OLEDB APIs.

Note  The language for a session can be changed during the session through SET LANGUAGE. For more information, see SET LANGUAGE.

For information about what the language for a session determines, see SQL Server Language Support. 

To set the default language