Displaying posts tagged with

“Not for replication”

Cannot insert explicit value for identity column in table ‘tablename’ when IDENTITY_INSERT is set to OFF

Error messages: Cannot insert explicit value for identity column in table ‘TableName’ when IDENTITY_INSERT is set to OFF. (Source: MSSQLServer, Error number: 544) Get help: http://help/544 Solution : You will get this type of error when you try to insert identity column in replication. You need to update column with not for replication. This option [...]