Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2004
    Posts
    2

    Unanswered: call sp_MSget_repl_commands(29, ?, 0, 7500000)

    any idea why i'm getting this error on replication?

    call sp_MSget_repl_commands(29, ?, 0, 7500000)

    Violation of PRIMARY KEY constraint 'PK__@snapshot_seqnos__2813BD1E'.
    Cannot insert duplicate key in object '#271F98E5'.

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    One of the target objects (being replicated) already has a row that replication is trying to insert. That is a bad thing.

    You need to discover which object is complaining, and what row is being inserted. Look at the replication tasks, in the job history to see the details of the problem.

    -PatP

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •