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_distcounters()MetaData:
create procedure sys.sp_distcounters
AS
SET NOCOUNT ON
--
-- Declarations.
--
DECLARE @distributor sysname
DECLARE @distribdb sysname
DECLARE @distproc nvarchar (300)
DECLARE @retcode int
--
-- Get distribution server information for remote RPC
-- subscription calls. If no distribution information, assume
-- replication is not being used.
--
EXEC @retcode = sys.sp_MSrepl_getdistributorinfo @rpcsrvname = @distributor OUTPUT,
@distribdb = @distribdb OUTPUT
IF @@error <> 0 OR @retcode <> 0 OR @distributor IS NULL OR
@distribdb IS NULL
RETURN (1)
--
-- Request counters from Distribution Server
--
SELECT @distproc = QUOTENAME(RTRIM(@distributor)) + '.' + QUOTENAME(RTRIM(@distribdb)) +
'.dbo.sp_MSdistribution_counters'
declare @publisher sysname
select @publisher = publishingservername()
EXEC @retcode = @distproc @publisher
No comments:
Post a Comment