HELP! MS SQL 2005 SD 7506 restore
Hi!
I can't restore database.
Problem with datetime columns
At the database dump Datetime format is YYYY-MM-DD and it can't be inserted to new database.
If I change it to format YYYY-DD-MM everything is OK
What should I do with that?
I can't restore database.
Problem with datetime columns
At the database dump Datetime format is YYYY-MM-DD and it can't be inserted to new database.
INSERT INTO Task_Input (INSTANCE_ID,SCHEDULE_ID,WORKFLOW_TEMPLATE_ID,SCHEDULE_TIME,EXECUTION_START_TIME,EXECUTION_FINISH_TIME,WORKENGINE_ID,ADMIN_STATUS,OPERATIONAL_STATUS,SERVER_ID,CRID) VALUES(2401, 3001, 19, NULL, N'2009-02-26 23:00:00.237', N'2009-02-26 23:00:00.423', 3, 3, 3, -1, 3902);
If I change it to format YYYY-DD-MM everything is OK
INSERT INTO Task_Input (INSTANCE_ID,SCHEDULE_ID,WORKFLOW_TEMPLATE_ID,SCHEDULE_TIME,EXECUTION_START_TIME,EXECUTION_FINISH_TIME,WORKENGINE_ID,ADMIN_STATUS,OPERATIONAL_STATUS,SERVER_ID,CRID) VALUES(2401, 3001, 19, NULL, N'2009-26-02 23:00:00.237', N'2009-26-02 23:00:00.423', 3, 3, 3, -1, 3902);
What should I do with that?