Hi All,

I have a database within SQL server which I connect to using a VB6 app. I recently had to re-build the SQL Server after a major system crash.

Now when my app attempts to retrieve data from the database, it is interpretting the dates as US and only returning dates that fall within the first 12 days of the month.

I have changed the regional settings to UK and selected the "set as system locale" tick option to ensure that all of the changes are set correctly and they look as if they are.

I have also re-set the locale ID within the system database back to 2057 for UK english but it is still mis-interpretting the dates.

I am beggining to pull my hair out, any help on this would be much appreciated.

Colin

SQL Server 7.0 sp4
VB6