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