I've just migrated a website built with asp and MsSQL to a new server. The old server used MsSQL 2000 nd the new one uses MsSQL 2005. I know the database became slightly corrupted when it was uploaded.
I was just wondering if anyone could tell whether the varchar to datetime error is likely to be caused by the database being corrupted of because the database is now using MSSQL 2005 instead of 2000.
I should also point out that I didn't design the website and my knowledge of asp and MSSQL is quite limited.
Cheers for any help.