sp_MSispublicationqueued (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_MSispublicationqueued(nvarchar @publisher
, nvarchar @publisher_db
, nvarchar @publication)

MetaData:

 create procedure sys.sp_MSispublicationqueued   
(  
    @publisher sysname  
    ,@publisher_db sysname  
    ,@publication sysname  
    ,@allow_queued_tran bit OUTPUT  
)  
as  
begin  
    --   
    --  security check  
    --  only db_owner can execute this  
    --   
    if (is_member ('db_owner') != 1)   
    begin  
        raiserror(14260, 16, -1)  
        return (1)  
    end  
    --   
    --  get the queued tran state for the publication  
    --   
    if object_id(N'MSpublications') is not NULL  
    begin  
        select @allow_queued_tran = pub.allow_queued_tran   
        from (dbo.MSpublications as pub join master.dbo.sysservers as srv  
                on pub.publisher_id = srv.srvid)  
        where UPPER(srv.srvname) = UPPER(@publisher)  
            and pub.publisher_db = @publisher_db  
            and pub.publication = @publication  
    end  
    else  
        select @allow_queued_tran = 0  
  
    --   
    --  all done  
    --   
    return 0  
end