I am trying to restore a SQL 2014 database in SQL 2005. I am doing by generating the complete script (with schema and data) from SQL 2014.
I get an error saying
'INSERT failed because the following SET options have incorrect settings: 'ANSI_PADDING'. Verify that SET options are correct for use with indexed views and/or indexes on computed columns and/or query notifications and/or xml data type methods.'
and
'Cannot insert explicit value for identity column in table 'T_GASAdminNote' when IDENTITY_INSERT is set to OFF.'
I have searched for solution but have not been able to rectify the problem. I have tried the solution given in this link, but it didnt help me.
Can anyone suggest me some solutions for restoring the database.
Aucun commentaire:
Enregistrer un commentaire