SQL Server help needed

[colin]

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

[Gary.Lowe]

Hi Colin

Have you tried rebuilding the database once you had reset all the locals?

[colin]

Hi Gary.

thanks for your reply, yes i have tried rebuilding after re-setting the locals. Does it make a difference which user you are logged in as ?? I have been logged in as admin but i havent quite got my head around the SQLadmin account and its role.

When i go into sql server query analyzer i can check the option for "Use regional settings for this connection" and it works great. I need to be able to set that as default for my database within sql server.

Cheers

Colin