May 8, 2012

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

Total Pageviews