May 14, 2012

sp_MSevaluate_change_membership_for_pubid (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_MSevaluate_change_membership_for_pubid(uniqueidentifier @pubid
, int @partition_id)

MetaData:

   
create procedure sys.sp_MSevaluate_change_membership_for_pubid (@pubid uniqueidentifier, @partition_id int = NULL) as
begin
declare @membership_eval_proc_name nvarchar(130), @retcode int

exec @retcode = sys.sp_MSrepl_PAL_rolecheck @pubid = @pubid
if @retcode<>0 or @@ERROR<>0
return 1

-- get the ArticleChangeMembershipEvaluation proc for each article in this publication.
declare membership_eval_proc_names CURSOR LOCAL FAST_FORWARD FOR select membership_eval_proc_name
from dbo.sysmergepartitioninfo
where pubid = @pubid and membership_eval_proc_name is not null and membership_eval_proc_name <> ' '
FOR READ ONLY

open membership_eval_proc_names

fetch next from membership_eval_proc_names into @membership_eval_proc_name

while (@@fetch_status <> -1)
begin
select @membership_eval_proc_name = 'dbo.' + @membership_eval_proc_name
exec @retcode = @membership_eval_proc_name @partition_id
if @@error <> 0 or @retcode <> 0
return 1

fetch next from membership_eval_proc_names into @membership_eval_proc_name
end

close membership_eval_proc_names
deallocate membership_eval_proc_names

return 0
end

No comments:

Post a Comment

Total Pageviews