October 24, 2007 at 1:13 am
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 ?.
October 24, 2007 at 7:39 am
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 ?
October 24, 2007 at 7:51 am
Better understand about replication configuration from MSDN / Technet website...
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply