title: date issue after migrating to SQL Server 2012
body: <p>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).</p>
  
  <p>We have tried changing <code>dbcc useroprions</code>. Currently they are set like this:</p>
  
  <pre><code>language    British
  dateformat  dmy
  datefirst   1
  </code></pre>
  
  <p>We changed it to <code>us-english</code> but it does not work. Do I need to restart DB engine?</p>
  
  <p>Kindly advise ASAP as it is affecting client. Thanks in advance</p>