create procedure sys.sp_MSmerge_dropdownlevelprocs
    @artid uniqueidentifier,
    @pubid uniqueidentifier
as
    declare @procname sysname
    declare @cmd nvarchar(1000)
    declare @procsuffix nvarchar(100)

    -- drop the ins/upd/sel procs which have names like sp_ins_*
    select @procsuffix = sys.fn_MSmerge_getartprocsuffix(@artid, @pubid)
    select @procname = 'sp_ins_' + @procsuffix
    if object_id(@procname, 'P') is not NULL
    begin
        select @cmd = 'drop procedure ' + @procname
        exec (@cmd)
        if @@error<>0
            goto error
    end

    select @procname = 'sp_upd_' + @procsuffix
    if object_id(@procname, 'P') is not NULL
    begin
        select @cmd = 'drop procedure ' + @procname
        exec (@cmd)
        if @@error<>0
            goto error
    end

    select @procname = 'sp_sel_' + @procsuffix
    if object_id(@procname, 'P') is not NULL
    begin
        select @cmd = 'drop procedure ' + @procname
        exec (@cmd)
        if @@error<>0
            goto error
    end

    select @procname = 'sp_sel_' + @procsuffix + '_pal'
    if object_id(@procname, 'P') is not NULL
    begin
        select @cmd = 'drop procedure ' + @procname
        exec (@cmd)
        if @@error<>0
            goto error
    end

    select @procname = 'sel_' + @procsuffix
    if object_id(@procname, 'P') is not NULL
    begin
        select @cmd = 'drop procedure ' + @procname
        exec (@cmd)
        if @@error<>0
            goto error
    end

    select @procname = 'sp_cft_' + @procsuffix
    if object_id(@procname, 'P') is not NULL
    begin
        select @cmd = 'drop procedure ' + @procname
        exec (@cmd)
        if @@error<>0
            goto error
    end

    return 0

error:
    return 1