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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-10-24 : 07:47:50
|
| Mindy H writes "View Conflicts is showing 21,000 conflicts on a particular table, but if we review the conflict_table for the table there are only 16,000 records in it. We often see this, what's the reason? How can we review all the conflicts? We want to query the tables directly to see how many of which type of reason the conflict occurred, to narrow down what we're dealing with.I'm referring to the conflict table itself, eg. conflict_mydb_mytable. The process creating the conflicts isn't the issue, some are because a record was edited on one side, and deleted on the other, or because of a trigger mismatch. I just want to be able to query the conflict table to summarize how many of which error there are.I'm trying to understand where the conflict total count is coming from because the number of records in conflict_mydb_mytable doesn't match the total number of records the conflict viewer interface in ent mgr lists for mytable. I see part of the total is also coming from msmerge_delete_conflicts." |
|
|
|
|
|
Understanding replication conflicts