Replication Issue

• DBA_007

  Ten Centuries

  Points: 1180

  More actions

  April 18, 2017 at 3:55 am

  #342515

  Iam receiving the below error from distribution agent

  Command attempted:
  if @@trancount > 0 rollback tran
  (Transaction sequence number: 0x0003160400008152004B00000000, Command ID: 1)

  Error messages:
  Explicit value must be specified for identity column in table 'XYZ' either when IDENTITY_INSERT is set to ON or when a replication user is inserting into a NOT FOR REPLICATION identity column. (Source: MSSQLServer, Error number: 545)

  I have set IDENTITY_INSERT to OFF but I receive the message as

  Cannot insert explicit value for identity column in table 'XYZ' when IDENTITY_INSERT is set to OFF.

  Any Suggestions.

• Thom A

  SSC Guru

  Points: 99129

  More actions

  April 18, 2017 at 3:59 am

  #1938466

  Duplicate of post https://www.sqlservercentral.com/Forums/1871233/Transactional-Replication-issue

  Thom~

  Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
  Larnu.uk