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_MSdummyupdate_logicalrecord(uniqueidentifier @parent_rowguid, int @parent_nickname
, bigint @dest_common_gen)
MetaData:
create procedure sys.sp_MSdummyupdate_logicalrecord @parent_rowguid uniqueidentifier, @parent_nickname int, @dest_common_gen bigint
as
declare @retcode int
exec @retcode = sys.sp_MSrepl_PAL_rolecheck @tablenick = @parent_nickname
if (@retcode <> 0) or (@@error <> 0)
return 1
update dbo.MSmerge_contents set generation = 0
where rowguid = @parent_rowguid
and tablenick = @parent_nickname
if @@rowcount = 0
begin
update dbo.MSmerge_tombstone set generation = 0
where rowguid = @parent_rowguid
and tablenick = @parent_nickname
end
update dbo.MSmerge_contents set generation = 0
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 > @dest_common_gen
update dbo.MSmerge_tombstone set generation = 0
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 > @dest_common_gen
if @@error <> 0
return 1
return 0
No comments:
Post a Comment