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_articlefilter(nvarchar @publication, nvarchar @article
, nvarchar @filter_name
, ntext @filter_clause
, bit @force_invalidate_snapshot
, bit @force_reinit_subscription
, nvarchar @publisher)
MetaData:
create procedure sys.sp_articlefilter ( @publication sysname, @article sysname, @filter_name nvarchar (517) = NULL, -- name of filter procedure @filter_clause ntext = NULL, @force_invalidate_snapshot bit = 0, -- Force invalidate existing snapshot @force_reinit_subscription bit = 0, -- Force reinit subscription @publisher sysname = NULL ) AS BEGIN DECLARE @cmd nvarchar(4000) ,@retcode int ,@publisher_type sysname EXEC @retcode = sys.sp_MSrepl_getpublisherinfo @publisher = @publisher, @publisher_type = @publisher_type OUTPUT, @rpcheader = @cmd OUTPUT IF @retcode <> 0 RETURN (@retcode) IF @publisher IS NULL select @publisher = publishingservername() -- Add sp select @publisher = UPPER(@publisher) ,@cmd = @cmd + N'sys.sp_MSrepl_articlefilter' EXEC @retcode = @cmd @publication, @article, @filter_name, @filter_clause, @force_invalidate_snapshot, @force_reinit_subscription, @publisher, @publisher_type RETURN (@retcode) END
No comments:
Post a Comment