0

I am facing an issue after we migrated our DB from SQL Server 2008 R2 to SQL Server 2012 in our production server. When we pass any date in yyyy-mm-dd format it changes it into yyyy-dd-mm and breaking all the applications. So in SQL itself datetime parameter in SP changed our value (to yyyy-dd-mm) passed from all our applications (live website and all other backend applications).

We have tried changing dbcc useroprions. Currently they are set like this:

language    British
dateformat  dmy
datefirst   1

We changed it to us-english but it does not work. Do I need to restart DB engine?

Kindly advise ASAP as it is affecting client. Thanks in advance

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
user3851995
  • 37
  • 1
  • 1
  • 5

1 Answers1

0

It worked after executing below SP.

sp_defaultlanguage 'DBUsername','us_english'

Thanks.

user3851995
  • 37
  • 1
  • 1
  • 5