New Information - SQL Server 2000 SP3.
Requires Service Pack 1 or later. Performs a manual cleanup of meta data in the MSmerge_genhistory, MSmerge_contents and MSmerge_tombstone system tables. This stored procedure is executed at each Publisher and Subscriber in the topology.
Return Code Values
0 (success) or 1 (failure)
sp_mergemetadataretentioncleanup requires SQL Server 2000 Service Pack 1 or later. See Merge Meta Data Cleanup in How Merge Replication Works for more information on meta data cleanup.
Important If there are multiple publications on a database, and any one of those publications uses an infinite publication retention period (@retention=0), running sp_mergemetadataretentioncleanup will not clean up the merge replication change tracking meta data for the database. For this reason, use infinite publication retention with caution.
Only members of the sysadmin fixed server role, the db_owner fixed database role, or the publication access list for at least one publication can execute sp_mergemetadataretentioncleanup.