sp_MSneedmergemetadataretentioncleanup (Transact-SQL MetaData) Definition

Please note: that the following source code is provided and copyrighted by Microsoft and is for educational purpose only.
The meta data is from an SQL 2012 Server.

I have posted alot more, find the whole list here.

Goto Definition or MetaData

Definition:

sys.sp_MSneedmergemetadataretentioncleanup(uniqueidentifier @replicaid)

MetaData:

 create procedure sys.sp_MSneedmergemetadataretentioncleanup  
    @replicaid      uniqueidentifier,  
    @needcleanup    bit output  
as  
    declare @REPLICA_STATUS_BeforeRestore tinyint  
    declare @pubid uniqueidentifier  
    declare @metadatacleanuptime datetime  
    declare @retcode int  
  
    exec @retcode = sys.sp_MSrepl_PAL_rolecheck @repid = @replicaid  
    if @@error<>0 or @retcode<>0  
        return 1  
  
    set @REPLICA_STATUS_BeforeRestore= 7  
    set @needcleanup = 0  
  
    select @pubid = pubid, @metadatacleanuptime = metadatacleanuptime from dbo.sysmergesubscriptions  
    where subid=@replicaid and  
    status<>@REPLICA_STATUS_BeforeRestore  
  
    if @pubid is not null  
        select @needcleanup= case when   
                                    sys.fn_add_units_to_date(-1, retention_period_unit, getdate()) > @metadatacleanuptime   
                                        then 1  
                                    else 0  
                             end  
        from dbo.sysmergepublications  
        where pubid = @pubid