Hi there,

Can someone help me with to change my default language to British English with date format DMY. Now, I ran this command:

exec sp_configure 'default language',23

And I got this message:

DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Configuration option 'default language' changed from 0 to 23. Run the RECONFIGURE statement to install.

Then I ran this command:

EXEC sp_configure

But when I check the properties of my server, it still displays my language setting as English (United States) with dateformat MDY - although my language setting in system tables show British.