You are currently offline, waiting for your internet to reconnect

INF: sp_mergecleanupmetadata Optimized for Speed and Less Disk Space Usage

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

Article ID: 274376 - Last Review: 10/21/2013 01:47:34 - Revision: 1.1

Microsoft SQL Server 7.0 Standard Edition

  • kbnosurvey kbarchive kbbug kbinfo kbpending KB274376