You cannot insert a display value into a table when IDENTITY_INSERT is set to OFF. (Source: MSSQLServer, error code: 544)

Error "Prompt for transaction and snapshot synchronization: You cannot insert a display value into a table when IDENTITY_INSERT is set to OFF. (Source: MSSQLServer, error code: 544) "

Cause: When SQL2008 is synchronized to sql2008/sql2005/sql2014 sometimes due to poor publishing configuration (replication Extended Properties =false)

Errors that occur when you add data to the synchronization:

Workaround 1: At the Publisher-Select Publish Item-Properties (Project)-Check (Table Object)-Properties (Copy extended property =True) as shown in Figure 1,

Then restart the SQL Agent service to start the snapshot snapshot (boot)

Workaround 2: Change the table extension properties at the Subscriber: to (NO)

Workaround 3:

Change the Subscriber identity column to a normal column (this method is not recommended), or you can resolve the synchronization.

You cannot insert a display value into a table when IDENTITY_INSERT is set to OFF. (Source: MSSQLServer, error code: 544)