Wednesday, March 21, 2012

Primary Key Issue

This is not my problem.
http://support.microsoft.com/default.aspx?scid=kb;en-
us;813494&Product=sql2k
I need to know how to prevent a replicated record from
being re-replicated. I know there is a flag. HELP!!!

>--Original Message--
>Running SQL 2K & Win 2K
>I have 16 servers that use trans. replication to a
>central server...
>I want to replicate all data to the central server, this
>is not a problem (Trans. Pub 1). Next, I want to filter
>the data and replicate location specific data to each
>server, this also is not a problem(Trans. Pub 2).
>The problem arises when Pub 2 inserts data on Server A,
>then Pub 1 attempts to insert it back on the central
>server. The distribution agent errors out with a
>Violation of PRIMARY KEY constrain error. How can I
>prevent Pub 1 from attempting to reinsert the records?
>.
>
..
you may be running into a loopback condition. If so use the
loopback_detection switch on sp_addsubscription, and set it to true.
"larry" <anonymous@.discussions.microsoft.com> wrote in message
news:391a01c4a567$3e9a9870$a301280a@.phx.gbl...
> This is not my problem.
> http://support.microsoft.com/default.aspx?scid=kb;en-
> us;813494&Product=sql2k
> I need to know how to prevent a replicated record from
> being re-replicated. I know there is a flag. HELP!!!
> .
>

No comments:

Post a Comment