Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Williem
Starting Member
3 Posts |
 Posted - 2007-10-24 : 03:08:13
|
| 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 ?. |
|
|
Williem
Starting Member
3 Posts |
Posted - 2007-10-24 : 09:36:40
|
| 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 ? |
 |
|
|
|
|
|
|
|
Merge replication - confict resolver