May 21, 2012

sp_MSinserterrorlineage (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_MSinserterrorlineage(int @tablenick
, uniqueidentifier @rowguid
, varbinary @lineage
, int @compatlevel)

MetaData:

   
create procedure sys.sp_MSinserterrorlineage
(@tablenick int,
@rowguid uniqueidentifier,
@lineage varbinary(311),
@compatlevel int = 10) -- backward compatibility level, default=Sphinx
as
declare @retcode int

-- Security Checking
-- PAL users have access
exec @retcode = sys.sp_MSrepl_PAL_rolecheck @tablenick = @tablenick
if (@retcode <> 0) or (@@error <> 0)
return 1
if @compatlevel < 90
set @lineage= {fn LINEAGE_80_TO_90(@lineage)}

if exists (select * from MSmerge_errorlineage where tablenick = @tablenick and
rowguid = @rowguid)
update MSmerge_errorlineage set lineage = @lineage where tablenick = @tablenick and
rowguid = @rowguid
else
insert into MSmerge_errorlineage (tablenick, rowguid, lineage)
values (@tablenick, @rowguid, @lineage)
if @@ERROR <> 0 return (1)

return 0

No comments:

Post a Comment

Total Pageviews