sp_MSenumreplicas (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_MSenumreplicas(uniqueidentifier @pubid)

MetaData:

   
create procedure sys.sp_MSenumreplicas (  
    @pubid uniqueidentifier)  
as  
    declare @inactive tinyint  
  
    --   
    --  Check to see if current publication has permission  
     --   
    if ({ fn ISPALUSER(@pubid) } <> 1)  
    begin     
        RAISERROR (14126, 11, -1)  
        return (1)  
    end  
  
    select @inactive = 0  
    if object_id('MSmerge_contents') is NULL  
    begin  
        RAISERROR(20054 , 16, -1)  
        return (1)  
    end  
  
    select subs.subid, {fn REPLNICK_90_TO_80(subs.replnickname)},   
           subs.subscriber_type, subs.subscription_type,   
           subs.priority, subs.schemaversion, subs.schemaguid, subs.datasource_type, subs.subscriber_server, subs.subscriber_server,    
           subs.db_name, subs.status, subs.pubid, subs.sync_type, subs.description, subs.pubid, pubs.name, pubs.distributor  
           from dbo.sysmergesubscriptions subs  
           left outer join dbo.sysmergepublications pubs  
           on subs.subid = pubs.pubid  
                where subs.status <> @inactive  
                    and subs.subscriber_type = 1  
                    --  If called by 8.0 reconciler on 9.0 replica: It does not know about status 7.  
                    and subs.status <> 7 --  REPLICA_STATUS_BeforeRestore  
                    order by convert(binary, subs.subid)  
    IF @@ERROR <>0 return (1)   
    return (0)