May 10, 2012

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

No comments:

Post a Comment

Total Pageviews