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