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_MSgetmetadata_changedlogicalrecordmembers(uniqueidentifier @parent_rowguid, bigint @commongen
, int @parent_nickname)
MetaData:
create procedure sys.sp_MSgetmetadata_changedlogicalrecordmembers
(@parent_rowguid uniqueidentifier,
@commongen bigint,
@parent_nickname int)
as
declare @retcode int
exec @retcode = sys.sp_MSrepl_PAL_rolecheck @tablenick = @parent_nickname
if (@retcode <> 0) or (@@error <> 0)
return 1
select mc.tablenick, mc.rowguid, mc.generation, type=2, mc.lineage, mc.colv1
from dbo.MSmerge_contents mc join
(select distinct nickname from dbo.sysmergepartitioninfoview where logical_record_parent_nickname = @parent_nickname)
as smpi
on mc.tablenick = smpi.nickname
and mc.logical_record_parent_rowguid = @parent_rowguid
and mc.generation > @commongen
UNION
select mc.tablenick, mc.rowguid, mc.generation, mc.type, mc.lineage, NULL
from dbo.MSmerge_tombstone mc join
(select distinct nickname from dbo.sysmergepartitioninfoview where logical_record_parent_nickname = @parent_nickname)
as smpi
on mc.tablenick = smpi.nickname
and mc.logical_record_parent_rowguid = @parent_rowguid
and mc.generation > @commongen
return 0
No comments:
Post a Comment