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_articlecolumn(nvarchar @publication, nvarchar @article
, nvarchar @column
, nvarchar @operation
, bit @refresh_synctran_procs
, bit @ignore_distributor
, int @change_active
, bit @force_invalidate_snapshot
, bit @force_reinit_subscription
, nvarchar @publisher
, bit @internal)
MetaData:
create procedure sys.sp_articlecolumn (
@publication sysname, -- The publication name --
@article sysname, -- The article name --
@column sysname = NULL, -- The column name --
@operation nvarchar(5) = N'add' -- Add or delete a column --
-- synctran
, @refresh_synctran_procs bit = 1 -- refresh synctran procs or not
, @ignore_distributor bit = 0
-- DDL
, @change_active int = 0
, @force_invalidate_snapshot bit = 0 -- Force invalidate existing snapshot --
, @force_reinit_subscription bit = 0 -- Force reinit subscription --
, @publisher sysname = NULL
-- Peer-To-Peer
, @internal bit = 0
)
AS
BEGIN
DECLARE @cmd nvarchar(4000)
DECLARE @cmd2 nvarchar(4000)
DECLARE @retcode int
DECLARE @publisher_type sysname
DECLARE @publisher_dbms sysname
DECLARE @publisher_version sysname
SET @retcode = 0
EXEC @retcode = sys.sp_MSrepl_getpublisherinfo @publisher = @publisher,
@rpcheader = @cmd OUTPUT,
@publisher_type = @publisher_type OUTPUT
IF @retcode <> 0
RETURN (@retcode)
SET @publisher = UPPER(@publisher) COLLATE DATABASE_DEFAULT
IF @publisher_type = N'MSSQLSERVER'
BEGIN
-- Add sp
set @cmd = @cmd + N'sys.sp_MSrepl_articlecolumn'
EXEC @retcode = @cmd
@publication,
@article,
@column,
@operation,
@refresh_synctran_procs,
@ignore_distributor,
@change_active,
@force_invalidate_snapshot,
@force_reinit_subscription,
@internal
END
ELSE
BEGIN
-- Set publisher DBMS and version (for getting default data type mapping)
SELECT @publisher_dbms = 'ORACLE'
set @cmd2 = @cmd + N'sys.sp_IHgetversion'
EXEC @retcode = @cmd2
@publisher = @publisher,
@version = @publisher_version OUTPUT
IF @retcode != 0 OR @@ERROR != 0
BEGIN
RETURN (1)
END
-- Add sp
set @cmd2 = @cmd + N'sys.sp_IHarticlecolumn'
EXEC @retcode = @cmd2
@publication,
@article,
@column,
@operation,
@refresh_synctran_procs,
@ignore_distributor,
@change_active,
@force_invalidate_snapshot,
@force_reinit_subscription,
@publisher,
@publisher_type,
@publisher_dbms,
@publisher_version
END
RETURN (@retcode)
END
No comments:
Post a Comment