title: Changing dateformat on a SQL Server DB and not on whole server to dd/mm/yyyy
body: <p>can anyone help, we have a sql server 2005 database installed (actually its an sql server 2000 attached to an sql server 2005 server) with the default server language language USA with dateformat like mm/dd/yy and we really need to keep it this way but currently just uploaded a new database to the server and this needs to have the dateformat for dd/mm/yyyy.</p>
  
  <p>Can i force a change just on a database and not the whole server? If i force the change on the whole server it will make all my other apps fail</p>
  
  <p>For example currently we have this sql statement which fails..</p>
  
  <p>SELECT * FROM sesiones WHERE ultimo_acceso &lt; '16/04/2009 13:36:17'</p>
  
  <p>but of course we can add this which now works</p>
  
  <p>SELECT * FROM sesiones WHERE ultimo_acceso &lt; Convert(datetime, '16/04/2009 13:36:17', 103)</p>
  
  <p>but the problem being is that there are a large number of sql statements within the application. The truth being is that the application is fairly old and we don't really want to make any changes to the source code..</p>
  
  <p>SO hence if we could force a a change just on the Database / the tables of specific database then this would suffice</p>
  
  <p>Any help really appreciated</p>