SQL Server 2005 - Changing the default language

Within SQL server 2005 management studio, open a new query window and paste the following query script into the window.

EXEC sp_configure 'default language', 23


Click on the 'Execute' toolbar button to execute the script, which will change the default language from installation default (usually American English) to British English.


Return to all articles