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_MSrepl_enumarticlecolumninfo(nvarchar @publisher, nvarchar @publication
, nvarchar @article
, bit @defaults)
MetaData:
CREATE PROCEDURE sys.sp_MSrepl_enumarticlecolumninfo
(
@publisher sysname,
@publication sysname,
@article sysname,
@defaults bit = 0
)
AS
BEGIN
DECLARE @retcode int
DECLARE @publisher_type sysname
DECLARE @cmd nvarchar(4000)
DECLARE @distribdb sysname
SET @retcode = 0
--
-- Security Check: require sysadmin
--
IF (ISNULL(IS_SRVROLEMEMBER('sysadmin'),0) = 0)
BEGIN
RAISERROR(21089,16,-1)
RETURN (1)
END
EXEC @retcode = sys.sp_MSrepl_getdistributorinfo @publisher = @publisher,
@publisher_type = @publisher_type OUTPUT,
@distribdb = @distribdb OUTPUT
IF @retcode <> 0
BEGIN
RETURN (@retcode)
END
IF UPPER(@publisher_type) IN ('ORACLE', 'ORACLE GATEWAY')
BEGIN
SET @cmd = QUOTENAME(@distribdb) + N'.sys.sp_ORAenumarticlecolumninfo'
EXEC @retcode = @cmd
@publisher,
@publication,
@article,
@defaults
END
ELSE
BEGIN
RAISERROR(21645, 16, -1, @publisher)
RETURN (1)
END
RETURN (@retcode)
END
No comments:
Post a Comment