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).