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