Change default login language

Introduction

The default language option specifies the default language for all newly created logins. To set default language, specify the langid value of the language you want. You can look up the langid value by querying the sys.syslanguages compatibility view.

Problem

Change default login language to us_english (if needed)

Solution

https://github.com/steverezhener/DBA/blob/master/Procedures/bestpractices.usp_change_server_login_default_language.sql

Based on

https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/configure-the-default-language-server-configuration-option?view=sql-server-ver16