Posted on: 4/27/2011 3:43:30 AM | Views : 343

I have an old application that runs on sql server 2000. I managed to get it working with sql server 2005 (for my new 64 bit windows 7 computer). I only have one problem: when I execute a report in the application (so this querry cannot be changed) which uses a date, the interpretation is wrong (mdy instead of dmy). The application cannot be changed, so how can I make sql server 2005 express use the dmy format? I'm a complete novice with sql server so please keep that in mind when answering.
In short I would like to configure SQL server 2005 express that it should interpret the date as dmy instead of mdy (as it does now). < ...

Go to the complete details ...