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