sp_MSdistributoravailable (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_MSdistributoravailable()

MetaData:

   
--   
--  Name:  
--         sp_MSdistributoravailable  
--   
--  Description:  
--         Procedure used to determine whether the distributor is available  
--   
--  Returns:  
--         0 == SUCCESS  
--         1 == FAILURE  
--               result set with distribution database as the only column  
--   
--  Security:  
--         public  
--   
--  Notes:  
--         This internal stored procedure is used to determine whether the   
--               distributor associated with the local server is available.    
--         If available, the name of the distribution db will be returned  
--         as the only column in the result set, and the return code will  
--         be set to zero.      
  
create procedure sys.sp_MSdistributoravailable  
AS  
BEGIN  
    DECLARE @distribdb sysname,  
        @retcode int  
  
    exec @retcode = sp_MSrepl_getdistributorinfo  
        @distribdb = @distribdb OUTPUT  
  
    select 'distribdb' = @distribdb  
   
    return @retcode  
END