sql server replication: Since our outsourced database team made some changes to the database we
are getting the following from the Distribution Agent Error Details:


{call sp_MSget_repl_commands(5, ?, 0, 7500000)}

Violation of PRIMARY KEY constraint 'PK__@snapshot_seqnos__7AB9340C'.
Cannot insert duplicate key in object '#79C50FD3'.

Violation of PRIMARY KEY constraint 'PK__@snapshot_seqnos__7AB9340C'.
Cannot insert duplicate key in object '#79C50FD3'.
(Source: INTRANETSVR (Data source); Error number: 2627)
---------------------------------------------------------------------------------------------------------------

The it's a transactional replica that has been running happily for some
time now, and I am only a db admin with very little experience in
trouble shooting.

thanks in advance.

Kev

Kev,
what type of setup do you have? Looks at first sight that you have vanilla
transactional replication and someopne has added a record onto the
subscriber manually and now the PK violation is occurring. You'll be able to
determine the problemattic record using sp_browsereplcmds and/or logging
http://support.microsoft.com/?id=312292. Afther that, if my guess is
correct, you'll have to update the subscriber record manually or delete it
and prtevent any further non-replicaiton changes to the subscriber.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)