sp_MShelpmergearticles (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_MShelpmergearticles(nvarchar @publication
, int @compatibility_level
, uniqueidentifier @pubidin)

MetaData:

 create procedure sys.sp_MShelpmergearticles  
    @publication sysname,  
    @compatibility_level int = 7000000,  --  backward compatibility level, default=Sphinx  
    @pubidin uniqueidentifier = NULL  
as  
    declare @pubid                  uniqueidentifier  
    declare @artid                  uniqueidentifier  
    declare @user_name              sysname  
    declare @guid_col               sysname  
    declare @identity_support       int  
    declare @nickname               int  
    declare @next_seed              bigint  
    declare @objid                  int  
    declare @qualname               nvarchar(270)  
    declare @retcode                int  
    declare @tablename              sysname  
    declare @range                  bigint  
    declare @threshold              int  
    declare @db_name                sysname  
    declare @has_joins              int  
    declare @article_filter_category int  
    declare @objid_looper           int  
    declare @indexcol               int  
    declare @rowcount1              int  
    declare @rowcount2              int  
    declare @use_partition_groups   smallint  
    declare @maxschemaguidforarticle uniqueidentifier  
          
    --   
    --  To public.  
     --   
    set nocount on  
    if (@publication is null)  
    begin  
        RAISERROR(14003, 16, -1)  
        return (1)  
    end  
          
    if object_id('MSmerge_contents') is NULL  
    begin  
        raiserror(20054, 16, -1)  
        return (1)  
    end  
      
    select @db_name = db_name()  
  
    if @pubidin is not NULL  
        set @pubid = @pubidin  
    else  
        select @pubid = pubid from dbo.sysmergepublications  
            where name = @publication and UPPER(publisher)=UPPER(publishingservername()) and publisher_db=@db_name  
  
    --  security check  
    if (@pubid is null) or {fn ISPALUSER(@pubid)} <> 1  
    begin  
        RAISERROR (21423, 11, -1, @publication)  
        return (1)  
    end  
      
    select @use_partition_groups = use_partition_groups from dbo.sysmergepublications where pubid = @pubid  
    if @use_partition_groups is null  
        select @use_partition_groups = 0  
  
    if (@use_partition_groups <= 0) or (@compatibility_level < 9000000)  
    begin  
        exec @retcode = sys.sp_MShelpmergearticles_nonpartgroups @publication, @compatibility_level, @pubidin  
        return @retcode  
    end  
      
    --  If the 7.0 merge agent is making this call then we need to make sure that the CLSID of the sp resolver is the old one and not the new one  
       for an 8.0 merge agent we map CLSIDs from all resolvers it has in common with 9.0  
       all this is done by calling fn_MSrepl_map_resolver_clsid  --   
  
    --  don't need compat level assume here that it is only called for 90+ compat level  
    --  Note: Need to convert clsid in Katmai and above to Yukon as well since they are different. Hotfix#801802  
    exec sys.sp_MShelpmergeselectarticles @pubid, @compatibility_level  
          
    return (0)