If you needed to change the default language of a SQL Server login you can do so by using sp_defaultlanguage command.
First determine the current default language by using the @@language variable as follows.
- SELECT @@language
Then choose the language you want to change to from the available languages. You can find the available languages by the following command.
- EXEC sys.sp_helplanguage
After selecting the language wanted to change, run the following command to change the default language, I am changing it to British using the following command.
- DECLARE @Login NVARCHAR(30)
- SET @Login = SYSTEM_USER
- EXEC sp_defaultlanguage @Login, 'British'
Run the @@language to see whether the default language is changed as you wanted. Do not forget to use a new query window to see the changes.
[…] Changing SQL Server Default Language […]