May 25, 2012

sp_MSrepl_enumtablecolumninfo (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_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

Total Pageviews