May 11, 2012

sp_MSdummyupdate_logicalrecord (Transact-SQL MetaData) Definition

Please note: that the following source code is provided and copyrighted by Microsoft and is for educational purpose only.
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

Total Pageviews