-- Create temp sp, no security check needed
create procedure sys.sp_MSmaketempinsertproc
(@tablename sysname, @procname sysname)
as
declare @qual_tablename nvarchar(140)
declare @qual_procname nvarchar(140)
select @qual_procname = QUOTENAME(@procname)
select @qual_tablename = QUOTENAME(@tablename)
-- now create the procedure
execute ('create procedure dbo.' + @qual_procname + '
( @p1 int, @p2 uniqueidentifier, @p3 int, @p4 nvarchar(255), @p5 tinyint) as
update ' + @qual_tablename + ' set tablenick = @p1, rowguid = @p2, errcode = @p3, errtext = @p4, type = @p5
where rowguid = @p2
if (@@rowcount = 0)
insert into ' + @qual_tablename + ' (tablenick, rowguid, errcode, errtext, type) values (@p1, @p2, @p3, @p4, @p5)')
if @@ERROR<>0
begin
return(1)
end