This is a discussion on Downloaded 100 data changes (0 inserts, 100 updates, 0 deletes, 0 conflicts) within the SQL Server forums, part of the Microsoft SQL Server category; --> I recently rolled out replication on our production server (MS SQL 2000 SP4) and every time a subscriber tries ...
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| 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?? |