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