Use the default language option to specify the ID of an available language in syslanguages. Microsoft® SQL Server™ is installed with 23 languages in syslanguages. This language support controls the default display formats for dates and the names of date parts such as month and day.
SQL Server is localized to French, German, Spanish, and Japanese. These localized versions of SQL Server contain two sets of system messages, one in U.S. English and one in the local language. If default language is set to the language ID of the local language on a localized server, SQL Server messages are displayed in the local language. If default language on a localized server is set to any language other than the local language, the messages are displayed in U.S. English. For example, if default language is set to Italian on a server running the German SQL Server version, the messages are displayed in U.S. English. Nonlocalized SQL Server versions contain U.S. English messages only. On those servers, messages are displayed in U.S. English regardless of the default language value.
Use default language to specify the ID of an available language specified in syslanguages. The language us_english always has an ID of 0.
The setting takes effect after stopping and restarting the server.
To set the default language
Character Set | Sort Order |
RECONFIGURE | sp_configure |
Setting Configuration Options |