sp_MShelp_subscription (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_MShelp_subscription(nvarchar @publisher
, nvarchar @publisher_db
, nvarchar @publication
, nvarchar @subscriber
, nvarchar @subscriber_db)

MetaData:

 CREATE PROCEDURE sys.sp_MShelp_subscription   
(  
    @publisher sysname,  
    @publisher_db sysname,  
    @publication sysname,          
    @subscriber sysname = '%',                
    @subscriber_db sysname = '%'  
)  
as  
begin  
    set nocount on  
    --   
    --  security check  
    --  only db_owner can execute this  
    --   
    if (is_member ('db_owner') != 1)   
    begin  
        raiserror(14260, 16, -1)  
        return (1)  
    end  
  
    select distinct ss.srvname + ':' collate database_default + s.subscriber_db, ss.srvname, s.subscriber_db, s.subscription_type,   
        sync_type, status, agent.name, agent.job_id from   
        dbo.MSsubscriptions s, master.dbo.sysservers ss, MSdistribution_agents agent where   
        s.publisher_id = (select srvid from master.dbo.sysservers where UPPER(srvname) = UPPER(@publisher)) and   
        s.publisher_db = @publisher_db and  
        s.publication_id = (select publication_id from dbo.MSpublications where   
            publisher_id = s.publisher_id and  
            publisher_db = s.publisher_db and  
            publication = @publication) and  
        ((@subscriber_db = N'%') or (s.subscriber_db = @subscriber_db)) and  
        s.subscriber_id = ss.srvid and  
        ((@subscriber = N'%') or (UPPER(ss.srvname) = UPPER(@subscriber))) and  
        s.subscriber_id >= 0 and                    --  ignore virtual subscriptions  
        s.agent_id = agent.id  
end