Laptop subscription conflicts - 01-26-2006 , 04:46 PM
We are having some data conflicts with some laptops that have "timed out"
and not finishing a synch. Once they are successful, will these conflicts
resolve themselves? For example one of the conflicts is due to a FK/PK
problem because (I think) that one of the tables did not get synched and the
failing one had records in it that related to that table. Is this possible?
Re: Laptop subscription conflicts - 01-26-2006 , 08:12 PM
Conflicts are always resolved. The winning row gets entered in the database,
the loosing row gets entered in the conflict tables.
The are always resolved - but perhaps not in the way you like Normally the
next time the agent will run the missing rows should be carried over. Note
that you will have to put the Not For Replication clause on all constraints
for this to happen.
Looking for a SQL Server replication book?
Looking for a FAQ on Indexing Services/SQL FTS
"David" <dlchase (AT) lifetimeinc (DOT) com> wrote