sp_MSenumretries (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_MSenumretries(nvarchar @tname
, int @maxrows
, int @tablenick
, uniqueidentifier @rowguid
, uniqueidentifier @pubid)

MetaData:

 create procedure sys.sp_MSenumretries  
    (@tname nvarchar(126),  
     @maxrows int,  
     @tablenick int,  
     @rowguid uniqueidentifier,  
     @pubid uniqueidentifier = NULL)  
as  
    declare @tnstring nvarchar(12)  
    declare @rgstring nvarchar(38)  
    declare @retcode int  
    declare @pubidstr varchar(38)  
    declare @last_art_processing_order int  
    declare @last_art_processing_order_str varchar(12)  
  
    declare @quotedtname nvarchar(744) --  386 * 2 + 2  
  
    --   
    --  do permission checking  
     --   
    exec @retcode = sys.sp_MSrepl_PAL_rolecheck @tablenick = @tablenick  
    if @retcode<>0 or @@ERROR<>0 return (1)  
  
    --   
    --  Modify temp table, granted to public.  
     --   
  
    declare @selecttop nvarchar(50)  
  
    select @quotedtname = quotename(@tname)  
  
    if (@maxrows = 0)  
        set @selecttop= 'select'  
    else  
        set @selecttop= 'select top ' + cast(@maxrows as nvarchar(9))   
      
        if @pubid is null  
        begin  
                if (@tablenick < 1)  
                begin  
                execute (@selecttop + ' * from ' + @quotedtname +   
                                        ' order by tablenick, rowguidcol')  
                        IF @@ERROR <>0 RETURN (1)          
                end  
                else  
                begin  
                set @tnstring = convert(nchar, @tablenick)  
                        set @rgstring = '''' + convert(nchar(36), @rowguid) + ''''  
                        execute (@selecttop + ' * from ' + @quotedtname +   
                                        ' where (tablenick = ' + @tnstring + ' and  rowguidcol > ' + @rgstring + ') or  
                                                tablenick > ' + @tnstring + ' order by tablenick, rowguidcol' )  
                        if @@ERROR <> 0 RETURN (1)  
                end  
        end  
        else  
        begin  
                select @pubidstr = '''' + convert(varchar(36), @pubid) + ''''  
                if (@tablenick < 1)  
                begin  
                execute (@selecttop + ' t.*   
                                        from ' + @quotedtname + ' t, dbo.sysmergearticles sma   
                                        where sma.nickname = t.tablenick   
                                        and sma.pubid = ' + @pubidstr + '  
                                        order by sma.processing_order, sma.nickname, t.rowguidcol')  
                        IF @@ERROR <>0 RETURN (1)          
                end  
                else  
                begin  
                set @tnstring = convert(nchar, @tablenick)  
                        set @rgstring = '''' + convert(nchar(36), @rowguid) + ''''  
                        exec sys.sp_MSget_article_processing_order @tablenick, @pubid, @last_art_processing_order output  
                        select @last_art_processing_order_str = convert(varchar, @last_art_processing_order)  
  
                        execute (@selecttop + ' t.*   
                                        from ' + @quotedtname + ' t, dbo.sysmergearticles sma  
                                        where sma.nickname = t.tablenick  
                                        and sma.pubid = ' + @pubidstr + '  
                                        and   
                                        (  
                                                (t.tablenick = ' + @tnstring + ' and  t.rowguidcol > ' + @rgstring + ') or  
                                                (sma.processing_order = ' + @last_art_processing_order_str + ' and t.tablenick > ' + @tnstring + ') or  
                                                sma.processing_order > ' + @last_art_processing_order_str + '  
                                        )  
                                        order by sma.processing_order, sma.nickname, t.rowguidcol' )  
                        if @@ERROR <> 0 RETURN (1)  
                end  
        end  
  
        return (0)