Posted by Benzine on 12/21/06 05:34

I recently rolled out replication on our production server (MS SQL 2000
SP4) and every time a subscriber tries to sync the following always
appears in the Merge Agent History:

"Downloaded 100 data changes (0 inserts, 100 updates, 0 deletes, 0
conflicts)"

Then at the very end of the "Action Messages" the following appears:

"Merged 31489 data changes (453 inserts, 30893 updates, 143 deletes, 14
resolved conflicts)."

Each sync always produces this large result. I don't understand what is
happening and why such a large amount of changes are suppose to be
happening. I could sync directly after the previous and get the same
result.

There are only 4 subscribers that merge with the publisher and all get
the same types of changes appearing.

Also MSmerge_contents table doesn't seem to be cleaned up after all
have synced, the table always contains approx 30000+ records.


Can anyone help please??

[Back to original message]