Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  General SQL Server Forums  Data Corruption Issues  migration issue for datetime in sqlserver 2008

Author  Topic  surya21 Starting Member 1 Post Posted - 2014-04-16 : 06:45:08 Hi, I have one datetime column(duedate) in sqlserver 2000. I migrated to sql server 2008.And i wrote " convert(char, RMI correctly.But when chssue.DueDate, 101) as DueDate ". When i click on the "DueDate" in the UI,it is displaying correctly.But when i changed to compatability level to "sql server 2008" and click on the DueDate from the UI,it is giving error"Page can not be displayed".Plese suggest