sp_MSenum_replsqlqueues (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_MSenum_replsqlqueues(nvarchar @curdistdb)

MetaData:

 create procedure sys.sp_MSenum_replsqlqueues  
(  
    @curdistdb    sysname = NULL  
)  
as  
begin  
    declare @distbit int  
    declare @db_name sysname  
    declare @cmd nvarchar(1024)  
  
    select @distbit = 16  
  
    --   
    --  create the temp table to store the relevant information  
    --   
    create table #replqueue (  
        publisher sysname collate database_default not null,  
        publisher_db sysname collate database_default not null,  
        subscriber sysname collate database_default not null,  
        subscriber_db sysname collate database_default not null,  
        publication sysname collate database_default not null,  
        dist_db sysname collate database_default not null  
    )  
    create unique index ucreplqueue ON #replqueue (subscriber, subscriber_db, publication)  
  
    --   
    --  Has the user specified a distribution database  
    --   
    if (@curdistdb is NULL)  
    begin  
        --   
        --  Go through all the distribution databases  
        --   
        declare hCdatabase CURSOR LOCAL FAST_FORWARD FOR   
            select name from master.dbo.sysdatabases   
            where  
                category & @distbit <> 0 and  
                has_dbaccess(name) = 1  
            for read only  
    end  
    else  
    begin  
        --   
        --  User specified Distribution Database  
        --  Validate the user specified name  
        --   
        if exists (select name from master.dbo.sysdatabases   
        where  
            name = @curdistdb and  
            category & @distbit <> 0 and  
            has_dbaccess(name) = 1)  
        begin  
            declare hCdatabase CURSOR LOCAL FAST_FORWARD FOR  
            select @curdistdb  
            for read only  
        end  
        else  
        begin  
            --   
            --  Error : Invalid distribution db specified  
            --   
            raiserror(20587, 16, 3, N'@curdistdb', N'sp_MSenum_replsqlqueues')  
            return 1  
        end  
    end  
      
    --   
    --  Enumerate  
    --   
    open hCdatabase  
    fetch next from hCdatabase into @db_name  
    while (@@fetch_status <> -1)  
    begin  
        select @cmd =  
        'SET NOCOUNT ON ' +  
        'INSERT INTO #replqueue (publisher, publisher_db, subscriber, subscriber_db, publication, dist_db) ' +  
        'SELECT c.srvname, a.publisher_db, b.srvname, a.subscriber_db, a.publication, N' + QUOTENAME(@db_name, N'''') + ' ' +  
        'FROM ' + QUOTENAME(@db_name) + '.dbo.MSdistribution_agents as a ' +  
            'JOIN master.dbo.sysservers as b ' +  
            'ON a.subscriber_id = b.srvid ' +  
            'JOIN master.dbo.sysservers as c ' +   
            'ON a.publisher_id = c.srvid ' +   
            'WHERE queue_id = N''mssqlqueue'' '  
              
        exec (@cmd)  
        fetch next from hCdatabase into @db_name  
    end  
    close hCdatabase  
    deallocate hCdatabase  
  
    --   
    --  select the contents of the temp table  
    --   
    select * from #replqueue  
  
    --   
    --  cleanup  
    --   
    drop table #replqueue  
end