sp_MSenumreplicas90 (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_MSenumreplicas90()

MetaData:

   
create procedure sys.sp_MSenumreplicas90  
as  
    declare @inactive tinyint  
  
    --  Security check  
    declare @retcode int  
    exec @retcode = sys.sp_MSrepl_PAL_rolecheck   
    if (@retcode <> 0) or (@@error <> 0)  
            return 1  
  
    select @inactive = 0  
    if object_id('sysmergesubscriptions') is NULL  
    begin  
        RAISERROR(20054 , 16, -1)  
        return (1)  
    end  
  
    select subs.subid, subs.replnickname,   
           subs.subscriber_type, subs.subscription_type,   
           subs.priority, subs.schemaversion, subs.schemaguid, subs.datasource_type, NULL, subs.subscriber_server,    
           subs.db_name, subs.status, subs.replicastate, subs.sync_type, subs.description, subs.pubid, pubs.name, pubs.distributor,  
           subs.replica_version  
           from dbo.sysmergesubscriptions subs  
           left outer join dbo.sysmergepublications pubs  
           on subs.subid = pubs.pubid  
           where subs.status <> @inactive  
               and subs.subscriber_type = 1  
               order by convert(binary, subs.subid)  
    IF @@ERROR <>0 return (1)   
    return (0)