"Benzine" wrote:

> I recently rolled out replication on our production server (MS SQL 2000
> 8.00.2039) 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)"
>
> This always takes over 5mins to complete.
> 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 a similar
> result.
>
>
> There are only 4 subscribers that merge with the publisher and all get
> the same types of messages 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??