How to: Set the Default Language (SQL Server Management Studio)
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.
To set the default language
In Object Explorer, right-click a server and select Properties.
Click the Misc server settings node.
In the Default language for users box, choose the language in which Microsoft SQL Server should display system messages.
The default language is English.