Article ID: 274376 - View products that this article applies to.
This article was previously published under Q274376
This article has been archived. It is offered "as is" and will no longer be updated.
The sp_mergecleanupmetadata system stored procedure introduced in Microsoft SQL Server 7.0 Service Pack 2 (SP2), allows administrators to clean up meta data in the MSmerge_contents and MSmerge_tombstone system tables to improve merge performance and save space by reducing the size of those tables at Publishers and Subscribers.
In case of large MSmerge_contents and MSmerge_tombstone tables, sp_mergecleanupmetadata requires a large amount of log space and time. This behavior is because all the deletions from both tables need to be recorded in the transaction log.
The sp_mregcleanupmetadata stored procedure has been optimized to improve performance in Microsoft SQL Server version 7.0 Service Pack 3 (SP3).