-- 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