Article ID: 274376
Article Last Modified on 10/15/2002
APPLIES TO
- Microsoft SQL Server 7.0 Standard Edition
This article was previously published under Q274376
SUMMARY
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.
MORE INFORMATION
The sp_mregcleanupmetadata stored procedure has been optimized to improve performance in Microsoft SQL Server version 7.0 Service Pack 3 (SP3).
Keywords: kbinfo kbbug kbpending KB274376
