sp_MScheckexistsgeneration (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_MScheckexistsgeneration(uniqueidentifier @genguid
, uniqueidentifier @pubid)

MetaData:

   
CREATE PROCEDURE sys.sp_MScheckexistsgeneration  
    (@genguid uniqueidentifier, @gen bigint output, @pubid uniqueidentifier = NULL)  
as  
    declare @retcode int  
    --   
    --  Check input parameter  
     --   
    if (@genguid is null)  
        begin  
            RAISERROR(14043, 16, -1, '@genguid', 'sp_MScheckexistsgeneration')  
            return (1)  
        end  
  
    --  security check  
    exec @retcode = sys.sp_MSrepl_PAL_rolecheck @pubid = @pubid  
    if (@retcode <> 0) or (@@error <> 0)  
        return 1  
  
    --  Normal case : do not qualify by pubid  --   
    if (@pubid IS NULL)  
        select @gen = max(generation) from dbo.MSmerge_genhistory where guidsrc = @genguid and genstatus in (1,2)  
    else          
    --  If we are reinitializing from an alternate publisher, check if the subscription has received generations for the alternate publication  --   
        select @gen = max(generation) from dbo.MSmerge_genhistory where guidsrc = @genguid and genstatus in (1,2)  
            and ((pubid = @pubid) or (pubid is null))         
    IF @@ERROR <>0 return (1)  
    --  OLEDB does not allow output parameter to be NULL - setting it to 0  --   
    return (0)