Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Merge Replication - conflict resolver Expand / Collapse
Author
Message
Posted Wednesday, October 24, 2007 1:13 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, September 07, 2008 11:17 PM
Points: 8, 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 ?.
Post #414228
Posted Wednesday, October 24, 2007 7:39 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, September 07, 2008 11:17 PM
Points: 8, 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 ?
Post #414426
Posted Wednesday, October 24, 2007 7:51 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: Banned Members
Last Login: Wednesday, February 19, 2014 3:34 AM
Points: 2,559, Visits: 326
Better understand about replication configuration from MSDN / Technet website...
Post #414443
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse