create procedure sys.sp_MSscript_compensating_send (
@pubid int,
@artid int,
@cmdstate int = 0,
@setprefix bit = 1)
AS
BEGIN
declare @cmd nvarchar(4000)
select @cmd = N'
' + N'
' + N'-- sending of compensating command
' + N'--'
insert into #proctext(procedure_text) values( @cmd )
select @cmd = N'
exec @retcode = sys.sp_MSadd_compensating_cmd
@orig_srv = @orig_server
,@orig_db = @orig_db
,@command = @cmd
,@article_id = ' + CAST(@artid as nvarchar(4)) + N'
,@publication_id = ' + CAST(@pubid as nvarchar(4)) + N'
,@cmdstate = ' + CAST(@cmdstate as nvarchar(4)) + N'
,@mode = 0
,@setprefix = ' + CAST(@setprefix as nvarchar(4))
insert into #proctext(procedure_text) values( @cmd )
select @cmd = N'
if (@@error != 0 or @retcode != 0)
return -1'
insert into #proctext(procedure_text) values( @cmd )
-- all done
return 0
END