sp_MSgetpubinfo (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_MSgetpubinfo(nvarchar @publication
, nvarchar @publisher
, nvarchar @pubdb)

MetaData:

   
create procedure sys.sp_MSgetpubinfo (  
    @publication    sysname,    --  The publication name  --   
    @publisher        sysname,  
    @pubdb            sysname  
    ) AS  
  
    SET NOCOUNT ON  
      
    -- don't further qualify with server name and DB name - it's just security checking  
    declare @retcode int  
    exec @retcode = sys.sp_MSrepl_PAL_rolecheck  
    if (@retcode <> 0) or (@@error <> 0)  
            return 1  
  
    select pubid from dbo.sysmergepublications where name = @publication and  
            LOWER(publisher) = LOWER(@publisher) and LOWER(publisher_db) = LOWER(@pubdb)