May 14, 2012

sp_MSforcereenumeration (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_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

Total Pageviews