SQL Server Server Properties -


i want change following server properties , settings in sql server 2012. want change language english(united states) english(united kingdom). please suggests me possible ways in order through.

enter image description here

the language setting of server doesn't matter, that's default setting new added user, haven't define language setting.

you have change language used account in sql server. in ssms goto "security" => "logins" , open properties of account, @ bottom of dialog find "default language", guess it's "english", change "british english".

or t-sql command:

use [master] go alter login [youraccountname] default_language=[british] go 

source : https://social.msdn.microsoft.com/forums/sqlserver/en-us/917d9534-ca26-4321-ab5a-1bf084cc7ee3/how-can-i-change-language-from-us-english-to-uk-english?forum=sqlexpress


Comments