sp_helpdistributor_properties (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_helpdistributor_properties()

MetaData:

 create procedure sys.sp_helpdistributor_properties   
     AS  
  
    declare @retcode int  
  
    --  Allow access if the user is 'sysadmin', member of 'db_owner' or 'repl_monitor'  
    --  role in a distribution database, or in the PAL of a publication whose publisher  
    --  uses this distributor.  
    exec @retcode = sys.sp_MSrepl_DistributorPALAccess  
    if (@retcode <> 0 or @@error <> 0)  
    BEGIN  
        DECLARE @login sysname  
        SET @login = suser_sname()  
        RAISERROR(21672, 16, -1, @login)   
        return (1)  
    END   
  
    if exists (select name from msdb.sys.objects where name = 'MSdistributor')  
    begin  
        --  There is currently only one property, so this will work  
        select 'heartbeat_interval' = convert(int, value) from msdb..MSdistributor where  
            property = 'heartbeat_interval'  
        return (0)  
    end  
    return (1)