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
No comments:
Post a Comment