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_MScreate_all_article_repl_views(bit @snapshot_application_finished)MetaData:
create procedure sys.sp_MScreate_all_article_repl_views @snapshot_application_finished bit = 0 as declare @pubid uniqueidentifier, @artid uniqueidentifier, @retcode int -- security check exec @retcode = sys.sp_MSreplcheck_subscribe if @retcode<>0 or @@ERROR<>0 return 1 select @retcode = 0 if object_id('sysmergesubsetfilters','U') is NULL return 0 declare artidpubid CURSOR LOCAL FAST_FORWARD FOR select artid, pubid from dbo.sysmergearticles FOR READ ONLY open artidpubid fetch artidpubid into @artid, @pubid while (@@fetch_status <> -1) begin exec @retcode = sys.sp_MScreate_article_repl_view @pubid, @artid if @@ERROR<>0 OR @retcode<>0 begin select @retcode = 1 goto error end fetch next from artidpubid into @artid, @pubid end if @snapshot_application_finished = 1 begin -- potentially there can be other post snapshot steps that can be done here execute @retcode= sys.sp_MSrepl_ddl_triggers @type='merge', @mode='add' if @@ERROR <> 0 or @retcode <> 0 begin select @retcode = 1 goto error end end error: close artidpubid deallocate artidpubid return @retcode
No comments:
Post a Comment