Sheridan Posted October 25, 2010 Posted October 25, 2010 I've got an old SQL 2000 Server which I want to move to a new server, running SQL Express 2005. I can restore the database to the new server no problems, but all of the date fields in my new database have changed. I.e In the old DB, I had a lot of datetime fields with a size of 8 (i.e 01/12/2010) as all that is required is the actual date. Now all of these fields appear as 01/12/2010 00:00:00 and this screws up all of my queries. The size is still showing in the new DB as 8, but its obviously got the time in there as well. Am I doing something wrong here, I don't recoding every date reference to cope with this!
Sheridan Posted October 25, 2010 Author Posted October 25, 2010 Ahhh I've found what was going wrong. The login in the new DB had defaulted to the British English language, on the original the login as English (as in US English) so the queries were coded to suit the US style of reverse dates. Setting the Login to English and the queries are working again. Simple fix but an easy one to miss! Thanks for the info though - I was hoping I wouldn't have to recode or redesign the tables!
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now