"Daniel" <anonymous@discussions.microsoft.com> wrote in message
news:D70CD02F-043D-471C-A38C-6D70E43AC44D@microsoft.com...
> any idea why i'm getting this error on replication
>
> All old subscription created on SP2 are working properly.
> We install SP3 to solve problem with overload of CPU (100% - sqlserver
continuosly).
>
> After installing SP3 I've encoutered next problem trying to create new
transactional subscription.
> Violation of PRIMARY KEY constraint 'PK__@snapshot_seqnos__2813BD1E'.
> Cannot insert duplicate key in object '#271F98E5'.
>
> After looking thru the microsoft site I found a reference that seemed
> close so I tried next:
> add the param @loopback_detection = 'true'
> to
> sp_addsubscription
>
> but it didin't work.
>
> We need to solve this problem till sunday - new location are starting !
> Thks.