Prompt when 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 Properties =True) as shown in Figure 1 ,

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

Workaround 2: Change the table extended properties at the Subscriber:

Workaround 3:

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

Prompt when 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)