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_MSset_logicalrecord_metadata(int @parent_nickname, uniqueidentifier @parent_rowguid
, varbinary @logical_record_lineage)
MetaData:
create procedure sys.sp_MSset_logicalrecord_metadata (@parent_nickname int, @parent_rowguid uniqueidentifier, @logical_record_lineage varbinary(311)) as declare @retcode smallint, @rowcount int, @error int exec @retcode = sys.sp_MSrepl_PAL_rolecheck @tablenick = @parent_nickname if (@retcode <> 0) or (@@error <> 0) return 1 update dbo.MSmerge_contents set logical_record_lineage = @logical_record_lineage where tablenick = @parent_nickname and rowguid = @parent_rowguid select @rowcount = @@rowcount, @error = @@error if @error <> 0 return 1 if @rowcount = 0 begin update dbo.MSmerge_tombstone set logical_record_lineage = @logical_record_lineage where tablenick = @parent_nickname and rowguid = @parent_rowguid select @rowcount = @@rowcount, @error = @@error if @error <> 0 return 1 -- if @rowcount = 0 begin declare @lineage varbinary(311), @replnick binary(6), @oldmaxversion int, @gen_cur bigint select top 1 @oldmaxversion = maxversion_at_cleanup, @gencur = gen_cur from dbo.sysmergearticles where nickname = @parent_nickname execute sys.sp_MSgetreplnick @replnick = @replnick output if @@error <> 0 return 1 set @lineage = { fn UPDATELINEAGE(0x0, @replnick, @oldmaxversion+1) } insert into dbo.MSmerge_contents (tablenick, rowguid, generation, partchangegen, lineage, colv1, marker, logical_record_parent_rowguid, logical_record_lineage, logical_record_change_gen) values(@parent_nickname, @parent_rowguid, @gencur, NULL, @lineage, 0x00, NULL, @parent_rowguid, @logical_record_lineage, NULL) if @error <> 0 return 1 end -- end return 0
No comments:
Post a Comment