Hello;

Setting the default language; It also determines the display format of months, days and dates. Unless you are using a different version (localized) of SQL Server, all output is in English. SQL Server; Available in French, German, Japanese, Spanish . System messages exist in two sets, one English and the other in the local language (whichever language is selected). If SQL Server has default language set to local language, it will show messages in local language. Otherwise, it will be displayed in English.

We go into

Server Properties. From the Advanced tab, we select the default language from Default Language. We restart the server for the settings to take effect.

sp_configure The Transact-SQL statement you can use is as follows;

exec sp_configure “default language”,

ID number for English is always “0”.