Re: Receiving 'PRIMARY KEY constraint 'PK__@snapshot_seqnos' error...

Have a look at this post.

http://groups.google.com/group/microsoft.public.sqlserver.replication/msg/7a54ed86febfd7b0?dmode=source

This will fix it. IIRC you will make this change on the distributor.
--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

"DTully" <DTully@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:45B780CE-96CF-45AE-8716-BE22A062C5FE@xxxxxxxxxxxxxxxx
> I'm adding a new subscriber to a transactional publication (no snapshot)
> and
> I'm receiving a 'Violation of PRIMARY KEY constraint
> 'PK__@snapshot_seqnos__543BF21A'. Cannot insert duplicate key in object
> '#5253A9A8'.' error. The subscriber, remote distributor and publisher are
> all
> running SP3.
>
> I did some research and it appears this is fixed in MS03-031:
> http://support.microsoft.com/default.aspx?scid=kb;en-us;813494
>
> Can this be installed just on the distributor w/o affecting the other
> systems? We actually have 5 other subscribers and some also publish to
> other
> subscribers and also to other publishers so I don't want to affect any of
> the
> other other servers.
>
> TIA!!
> Darin


.

Relevant Pages

  • Re: Inactive Publisher??????
    ... The publisher name is in ALL CAPS. ... disabling distribution on the distributor and then rebooting ... made sure the other server was set up for publication. ... I then imported data from the publisher to the subscriber so that the ...
    (microsoft.public.sqlserver.replication)
  • Re: Inactive Publisher??????
    ... wondering if you initially setup replication under a low-privileged account ... I then imported data from the publisher to the subscriber so that the ... So I set up my subscriber as the distributor using the wizard. ...
    (microsoft.public.sqlserver.replication)
  • Re: Non-trusted transactional replication with remote distributor?
    ... between the publisher and the distributor/subscriber. ... Why do you feel the need to have a remote distributor? ... Looking for a SQL Server replication book? ... > also a subscriber, and one additional subscriber. ...
    (microsoft.public.sqlserver.replication)
  • Re: Inactive Publisher??????
    ... MSdistpublishers table in msdb on the distributor server shows the ... Shouldn't the publisher server have is_publisher=1? ... I then imported data from the publisher to the subscriber so that the ...
    (microsoft.public.sqlserver.replication)
  • Re: Inactive Publisher??????
    ... I then imported data from the publisher to the subscriber so that the schema ... So I set up my subscriber as the distributor using the wizard. ... From the publication, I launch the New ...
    (microsoft.public.sqlserver.replication)