By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
458,088 Members | 1,242 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 458,088 IT Pros & Developers. It's quick & easy.

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

P: n/a
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??

Dec 21 '06 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.