SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Merge Replication - conflict resolver


Merge Replication - conflict resolver

Author
Message
William-462471
William-462471
SSC Rookie
SSC Rookie (48 reputation)SSC Rookie (48 reputation)SSC Rookie (48 reputation)SSC Rookie (48 reputation)SSC Rookie (48 reputation)SSC Rookie (48 reputation)SSC Rookie (48 reputation)SSC Rookie (48 reputation)

Group: General Forum Members
Points: 48 Visits: 61
Hi, I use push merge replication between Sql Server 2000 desktop and Sql Server 2000 desktop, and pull merge replication with one of desktop pc (so sql server 2000) and PDA subscriber, so sql server ce 3.0.
I use conflict resolver name : Subscriber Always Wins in conflict resolver to two tables, which interest me mostly, the others are set up like use default resolver.
I know, all updates rows deposit into tables : msMerge_contents and msMerge_tombstone. If I test count rows in table msMerge_contents with tablenick corresponding article, and count rows in table with same article, count rows it's same.
like this :
select count(*)
from MSMerge_contents
where tablenick in (select nickname
from sysmergearticles
where name = 'tableXXX')
and exists(select * from tableXXX
where rowguid = MSMerge_contents.rowguid)

select count(*)
from MSMerge_contents
where tablenick in (select nickname
from sysmergearticles
where name = 'tableXXX')

I use SP3 for Sql server 2000 and not long ago I must install fix for sql server 2000, named SQL2000-KB815495-8.00.0818-ENU.

Perhaps two day I see in Enterprise Manager, how there's a conflict resolver error by publisher, but nowhere in consistent table isn't enter for.
My question is, if is possible, that make set up "use default resolver", which don't put rows in consistent table, or is there other problem ?.
William-462471
William-462471
SSC Rookie
SSC Rookie (48 reputation)SSC Rookie (48 reputation)SSC Rookie (48 reputation)SSC Rookie (48 reputation)SSC Rookie (48 reputation)SSC Rookie (48 reputation)SSC Rookie (48 reputation)SSC Rookie (48 reputation)

Group: General Forum Members
Points: 48 Visits: 61
There's a command for record of conflict errors in Merge replication.
dbcc incrementinstance ("SQL Replication Merge", "Conflicts", @agent_name, @perfmon_conflict_count).

But how state which rows or sql command caused conflict between Publisher and Subscriber.
Know someone about dbcc incrementinstance more, for example some book ?
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search