Set the date format for SQL Express

Question

How do I set the date format for SQL Express in the UK format (dd / mm / yyyy).

I know that I can use SET DATEFORMAT DMY , but this only works for this connection.

I also saw

 exec sp_addlanguage 'British', 'English', 'January,February,March,April,May,June,July,August,September,October, November,December', 'Jan,Feb,Mar,Apr,May,Jun,Jul,Aug,Sep,Oct,Nov,Dec', 'Monday,Tuesday,Wednesday,Thursday,Friday,Saturday,Sunday' ,dmy,1 sp_configure 'default language', 1 

reconfigure with override

but it doesn't seem to work with SQL Express (I get, I cannot find the stored procedure "sp_addlanguage".).

Greetings

Answer 1

You must install the language using sp_configure

 EXEC sp_configure 'default language', '23' -- british_english ? GO RECONFIGURE; 

Edit: you need to use the code from sys.syslanguages ​​as indicated

However, by default, langauge will also need to be changed for all logins. Therefore, @@ langage shows us_english.