sp_MSpeerdbinfo (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_MSpeerdbinfo()

MetaData:

 --   
--  Name:   
--         sp_MSpeerdbinfo  
--    
--  Description:   
--         Checks to see if this database contains any peer to peer publications. If so, it  
--         will also output the guid restore version value as an int.  
--        
--  Parameters:   
--          See the procedure definition.  
--   
--  Returns:   
--         0 - succeeded  
--       1 - failed  
--   
--  Result:   
--         None  
--   
--  Security:   
--         Called by logreader agents  (must be made public).  
--         SYSADMIN or DBO of publisher db  
--   
create procedure sys.sp_MSpeerdbinfo  
(  
    @is_p2p                bit output,  
    @current_version     int output  
)  
as  
begin  
    declare @retcode int  
      
    declare @OPT_ENABLED_FOR_P2P int  
      
    select @OPT_ENABLED_FOR_P2P = 0x1  
  
    --  Security Check  
    exec @retcode = sys.sp_MSreplcheck_publish  
    if @@error <> 0 or @retcode <> 0  
    begin  
        return 1  
    end  
      
    --  only retrieve the data if the database is published. return   
    --  error since this should not be called on non-published db  
    if sys.fn_MSrepl_istranpublished(db_name(),0) != 1  
    begin  
        select @is_p2p = 0,  
                @current_version = 0  
  
        return 1  
    end  
  
    --  check if any publication is enabled for P2P  
    if exists (select *  
                from syspublications   
                where (options & @OPT_ENABLED_FOR_P2P) = @OPT_ENABLED_FOR_P2P)  
    begin  
        select @is_p2p = 1  
  
        exec @retcode = sys.sp_MSgetdbversion @current_version = @current_version output  
        if @@error <> 0 or @retcode <> 0  
            return 1  
    end  
    else  
    begin  
        select @is_p2p = 0,  
            @current_version = 0  
    end  
  
    return 0  
end