May 10, 2012

sp_MSdeletetranconflictrow (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_MSdeletetranconflictrow(nvarchar @tran_id
, nvarchar @row_id
, nvarchar @conflict_table)

MetaData:

   
create procedure sys.sp_MSdeletetranconflictrow (
@tran_id sysname,
@row_id sysname = '%', -- % = ALL
@conflict_table sysname)
as
begin
set nocount on
declare @retcode int
,@cmd nvarchar(4000)
,@startoffset int
,@table sysname
,@schema sysname

--
-- Security check. restrict to 'sysadmin' and member of db_owner role
--
exec @retcode = sys.sp_MSreplcheck_publish
if @@ERROR <> 0 or @retcode <> 0
return (1)

if (@conflict_table is NULL)
begin
raiserror(14043, 16, 1, '@conflict_table', 'sp_MSdeletetranconflictrow')
return (1)
end
--
-- check if the conflict table is owner qualified
-- and build the delete string as necessary
--
select @table = PARSENAME(@conflict_table, 1),
@schema = PARSENAME(@conflict_table, 2)

select @cmd = 'delete ' + ISNULL(NULLIF(QUOTENAME(@schema) + N'.', N'.'), N'') + QUOTENAME(@table)
+ ' where tranid = ' + QUOTENAME(@tran_id, '''')

if (@row_id != N'%')
begin
select @cmd = @cmd +
' and qcfttabrowid = ' + QUOTENAME(@row_id, '''')
end

execute (@cmd)
end

No comments:

Post a Comment

Total Pageviews