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_enumtablecolumninfo(nvarchar @publisher, nvarchar @owner
, nvarchar @tablename)
MetaData:
CREATE PROCEDURE sys.sp_MSrepl_enumtablecolumninfo
(
@publisher sysname,
@owner sysname,
@tablename sysname
)
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_ORAenumtablecolumninfo'
EXEC @retcode = @cmd
@publisher,
@owner,
@tablename
END
ELSE
BEGIN
RAISERROR(21645, 16, -1, @publisher)
RETURN (1)
END
RETURN (@retcode)
END
No comments:
Post a Comment