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_MSsetgentozero(int @tablenick, uniqueidentifier @rowguid
, tinyint @metatype)
MetaData:
create procedure sys.sp_MSsetgentozero
(@tablenick int,
@rowguid uniqueidentifier,
@metatype tinyint= null)
as
declare @retcode int
declare @METADATA_TYPE_Tombstone tinyint
declare @METADATA_TYPE_Contents tinyint
declare @METADATA_TYPE_PartialDelete tinyint
declare @METADATA_TYPE_SystemDelete tinyint
set @METADATA_TYPE_Tombstone= 1
set @METADATA_TYPE_Contents= 2
set @METADATA_TYPE_PartialDelete= 5
set @METADATA_TYPE_SystemDelete= 6
if (@rowguid is null)
begin
RAISERROR(14043, 16, -1, '@rowguid', 'sp_MSsetgentozero')
return (1)
end
if (@tablenick is null)
begin
RAISERROR(14043, 16, -1, '@tablenick', 'sp_MSsetgentozero')
return (1)
end
if (@metatype is not null and
@metatype not in (@METADATA_TYPE_Tombstone,
@METADATA_TYPE_Contents,
@METADATA_TYPE_PartialDelete,
@METADATA_TYPE_SystemDelete))
begin
-- RAISERROR(20052, 16, -1)
return 0
end
-- security check
exec @retcode = sys.sp_MSrepl_PAL_rolecheck @tablenick = @tablenick
if (@retcode <> 0) or (@@error <> 0)
return 1
if @metatype in (@METADATA_TYPE_Tombstone,
@METADATA_TYPE_PartialDelete,
@METADATA_TYPE_SystemDelete)
begin
update dbo.MSmerge_tombstone
set generation = 0
where tablenick = @tablenick and rowguid = @rowguid
end
else if @metatype = @METADATA_TYPE_Contents
begin
update dbo.MSmerge_contents
set generation = 0
where tablenick = @tablenick and rowguid = @rowguid
update dbo.MSmerge_past_partition_mappings
set generation = 0
where tablenick = @tablenick and rowguid = @rowguid
end
else
begin
update dbo.MSmerge_tombstone
set generation = 0
where tablenick = @tablenick and rowguid = @rowguid
if 0 = @@rowcount
begin
update dbo.MSmerge_contents
set generation = 0
where tablenick = @tablenick and rowguid = @rowguid
end
update dbo.MSmerge_past_partition_mappings
set generation = 0
where tablenick = @tablenick and rowguid = @rowguid
end
return 0
No comments:
Post a Comment