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 sets identity off for the records which are coming throw replication.

Use SubscriberDBName
Go
Alter Table TableName
Alter Column ColumnName Not For Replication -- Your Identity column.