Hello,



Please help me.



I have installed MSSQL 2000 Standard, on a server which had the regional
settings set to US Standard. This has caused our custom ASP.net application
date formatting errors, as the standard format is dmy within the
application. I have tried to change the regional settings of the computer to
Australia, but this has not had any affect. I then uninstalled MSSQL 2000
and tried reinstalling without and success. Then I tried to create a new
language "AUSTRALIAN" and included the set the date format to dmy, and set
the language to default. This too had no affect. I am running out of options
to try.



If this does not make any since, the easiest way to describe it is: if I run
the following SQL statement I get a date time formate error.



Insert into Table

values

(

'20\05\2003'

)



as the date format is dmy and SQL Server is expecting the input as mdy. I
can not change the SQL statements to include 'Set dateformat' statements or
any other modifications.



The application works fine on 4 other computers that had the regional
settings set to Australia before install MSSQL 2000.



Please help me find a solution.



Regards,

Bernard.

also check "default language Option" in BOL

Check all logins for their language-setting.

jobi
"jobi" <jobi (AT) reply2 (DOT) group> wrote