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