sp_helpreplicationoption (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_helpreplicationoption(nvarchar @optname)

MetaData:

   
create procedure sys.sp_helpreplicationoption (  
@optname        sysname = NULL  
)  
AS  
    DECLARE @optbit bit  
    DECLARE @retcode int  
  
  
    IF @optname IS NOT NULL AND LOWER(@optname collate SQL_Latin1_General_CP1_CS_AS) NOT IN ('transactional','merge')  
    BEGIN  
        RAISERROR(21014, 16, -1)  
        GOTO FAILURE  
    END  
    SELECT optname, value, major_version, minor_version, revision   
        FROM master.dbo.MSreplication_options  
        WHERE  
            optname = @optname OR  
            @optname = NULL  
  
    RETURN(0)  
  
FAILURE:  
    RETURN(1)