We have a very weird problem here.
When dealing with dates (using CAST or CONVERT) the sa account translates them in the wrong Country format... We are in UK so our date formats are "dd-mm-yyyy" but whatever we do sa thinks we mean "mm-dd-yyyy".
We've changed the sa default language but nothing is different. All other logins to this server work as expected.
The odd thing about this was that it was OK then changed about the time some other software was installed on the server (some legecy software called Compaq Batch Server) which stores data on an SQL-Server database, but I can think of no reason that would do anything related to our problem.
This is SQL-Server 7 with service pack 3. The host machine is NT4 with all the lastest hotfixes. The machines default locale is UK and keyboard layout is also UK-English.
Anyone got any ideas on how to change the date translations for this account?
Cheers
Sam