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_MSmap_partitionid_to_generations(int @partition_id)MetaData:
create procedure sys.sp_MSmap_partitionid_to_generations @partition_id int
as
declare @retcode smallint
exec @retcode = sys.sp_MSrepl_PAL_rolecheck
if (@retcode <> 0) or (@@error <> 0)
return 1
if exists (select * from dbo.MSmerge_contents)
begin
insert into dbo.MSmerge_generation_partition_mappings (publication_number, partition_id,
generation, changecount)
select cpm.publication_number, cpm.partition_id, mc.generation, count(*)
from dbo.MSmerge_current_partition_mappings cpm join dbo.MSmerge_contents mc
on mc.tablenick = cpm.tablenick
and mc.rowguid = cpm.rowguid
and cpm.partition_id = @partition_id
group by cpm.publication_number, cpm.partition_id, mc.generation
end
insert into dbo.MSmerge_generation_partition_mappings (publication_number, partition_id,
generation, changecount)
select ppm.publication_number, ppm.partition_id, ppm.generation, count(*)
from dbo.MSmerge_past_partition_mappings ppm
where ppm.partition_id = @partition_id
group by ppm.publication_number, ppm.partition_id, ppm.generation
return 0
No comments:
Post a Comment