title: How can I force SQL Azure to accept DMY in query string?
body: <p>We have a range of legacy applications that we are trying to migrate to SQL Azure. The applications are written in Classic ASP with lots of string based queries. There are to many to rewrite to make it worth migrating.</p>
  
  <p>Any queries with dates are failing as the SQL string queries use UK DMY format. SQL Azure user and DB seem hard set to use use US English format.</p>
  
  <p>If I add SET DATEFORMAT dmy; before a query string the query then works. However this requires change thousands of queries. Is there anyway to force SQL Azure to use DMY format as part of the connection string? That or or some other solution that saves us re-writing thousands of queries? Any way to set a login to always use DMY format or to have the whole DB use DMY etc?</p>
  
  <p>Thanks</p>
  
  <p>Graeme</p>