all groups > sql server replication > july 2004 >
You're in the

sql server replication

group:

populating conflict tables


populating conflict tables jane201315 NO[at]SPAM yahoo.com
7/7/2004 6:55:51 AM
sql server replication:
Hi,
I am using the default conflict resolver given by sql server 2000
(datetime(later wins)) for resolving conflicts in merge replication.
For all the conflicts resolved by this resolver, there is no record of
the conflicts in the conflict table. Is there a way one could keep the
records when say the same row was changed at two places though the
conflict resolver resolves the conflicts based on the latest update?

Any suggestions/help is greatly appreciated.

Thanks,
Re: populating conflict tables Hilary Cotter
7/7/2004 10:29:37 AM
the conflict tables on the Publisher or Subscriber (depending what kind of
replication you are doing) should contain a record of any conflicts.

When you use the Conflict Viewer these conflicts should show up there, but
sometimes don't. Check the underlying conflict tables for this article and
see if the records are there.

--
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html


[quoted text, click to view]

Re: populating conflict tables jane201315 NO[at]SPAM yahoo.com
7/7/2004 1:16:23 PM
Hi Hilary,
I am using a push subscription. So, the conflict tables should be
populated on the publisher. They do get populated when I do not use
the default resolvers. But when I do use the resolvers, and say change
the same value in a row on the publisher and the subscriber, the
conflict is not recorded but is resolved as per the default resolver,
in my case the datetime(later wins) resolver.
Any idea why it does not record this in the conflict tables?
I appreciate your help!

Thanks,
Jane.

[quoted text, click to view]
conflict tables jane201315 NO[at]SPAM yahoo.com
7/12/2004 2:08:14 PM
Hi,

I would very much appreciate any help regarding this problem. In short
again, when there are no conflict resolvers, an update of the same row
in the publisher and subscriber creates an entry in the conflict
table. But, when I use say datetime (Later wins) conflict resolver, no
such entry is found in the conflict table. Is there a way, one could
use the resolvers and at the same time have the conflict listings in
the table for the record?
Thanks in advance!

Jane.


[quoted text, click to view]
Re: conflict tables Hilary Cotter
7/13/2004 10:29:04 AM
do you have a datetime column in this table? You must have one for this to
work.
[quoted text, click to view]

Re: conflict tables jane201315 NO[at]SPAM yahoo.com
7/15/2004 12:52:04 PM
Hi Hilary,
I do have a datetime column, I have set it up as the column to be used
for datetime(Later wins) conflict resolver. It works fine. But without
the resolver I do find conflicts in my conflict table. But with the
resolver set, my conflict table is empty even when the conflicts are
being created.
Any help is greatly appreciated!

Thanks in advance!
Jane.

[quoted text, click to view]
Re: conflict tables Ann
7/28/2004 4:14:01 AM

[quoted text, click to view]

Hi Jane!

Did you ever find any solution to your problem? I have the same situation here. I'm using msde merge pull replication and I cannot find data in the conflict table. However, unlike you, even if I try to remove the conflict resolver (datetime, later wins), I still can't see the log. Conflict table does exists but it remains empty, no matter what I do.

I would appreciate any help.

AddThis Social Bookmark Button