Duplicate Replication command in same transaction

• Mike.Hahn

  SSCarpal Tunnel

  Points: 4053

  More actions

  August 29, 2019 at 3:48 pm

  #3675481

  I'm confused.

  Had a replication error where the distribution agent reported that a record could not be found to delete.  I assumed it was because the record was deleted by someone on the subscriber but it was still there.

  When I looked into it I found something odd.  I ran the command below to see what commands are sitting at the distributor:

  EXEC sp_browsereplcmds 'xxx', 'xxx', @publisher_database_id = 1

  This is what I saw for the first 6 command (the identity of the sp and key have been modified to protect the innocent).

  It was deleting the same data 6 times... anyone know how this could happen???

  

  ---------------------------------------------------------------
  Mike Hahn - MCSomething someday:-)
  Right way to ask for help!!
  http://www.sqlservercentral.com/articles/Best+Practices/61537/
  I post so I can see my avatar :hehe:
  I want a personal webpage 😎
  I want to win the lotto 😀
  I want a gf like Tiffa :w00t: Oh wait I'm married!:-D

• Site Owners

  SSC Guru

  Points: 80330

  More actions

  August 30, 2019 at 4:10 pm

  #3675787

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.