How To Change The Language And Date Format In Sql Server?

I am using SQL Server 2005. When I execute DBCC USEROPTIONS, I see the language as romana and dateformat as dmy. I want the language to be us_english and dateformat as mdy. How c

Solution 1:

You can reset the language by using the below syntax

setlanguage'us_english'

In order to view all the languages and their date format try this one

select * from sys.syslanguages

If you need to permanently change the language then

• Go To Security
• Logins
• Right Click on your username and select Properties
• Change the default language to English

This change will persist even after you restart your SSMS

Solution 2:

Before

DBCC USEROPTIONS

is returning something like this:

---

To change your or UserLogin configuration run:

USE [master]
GO

ALTER LOGIN [UserLogin] WITH DEFAULT_LANGUAGE=[us_english]
GO

Next - reconnect to SQL (logout -> login).

After

You will get this: