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_MSforcereenumeration(int @tablenick, uniqueidentifier @rowguid)
MetaData:
create procedure sys.sp_MSforcereenumeration
@tablenick int,
@rowguid uniqueidentifier
as
declare @METADATA_TYPE_UpdateLightweight tinyint
declare @METADATA_TYPE_DeleteLightweight tinyint
declare @METADATA_TYPE_DeleteLightweightProcessed tinyint
declare @COLUMNS_ENUMERATED_AllOnConflictOrError int
declare @retcode int
exec @retcode = sys.sp_MSreplcheck_subscribe
if @retcode <> 0 or @@error <> 0 return 1
set @METADATA_TYPE_UpdateLightweight= 8
set @METADATA_TYPE_DeleteLightweight= 10
set @METADATA_TYPE_DeleteLightweightProcessed= 12
set @COLUMNS_ENUMERATED_AllOnConflictOrError= 1
update dbo.MSmerge_rowtrack
set changetype= case changetype
when @METADATA_TYPE_DeleteLightweightProcessed then @METADATA_TYPE_DeleteLightweight
when @METADATA_TYPE_DeleteLightweight then @METADATA_TYPE_DeleteLightweight
else @METADATA_TYPE_UpdateLightweight
end,
columns_enumeration= case changetype
when @METADATA_TYPE_DeleteLightweightProcessed then columns_enumeration
when @METADATA_TYPE_DeleteLightweight then columns_enumeration
else @COLUMNS_ENUMERATED_AllOnConflictOrError
end,
changed= sys.fn_MSdayasnumber(getdate())
where tablenick = @tablenick and
rowguid = @rowguid
if @@error <> 0 return 1
return 0
No comments:
Post a Comment