create procedure sys.sp_MScleanup_publication_ADinfo
@name sysname,
@database sysname
AS
SET NOCOUNT ON
declare @mergepublish_bit int
declare @tranpublish_bit int
declare @cmd nvarchar(640)
select @mergepublish_bit = 4
select @tranpublish_bit = 1
/*
** Security Check
*/
select @cmd = quotename(@database) + '.sys.sp_MSreplcheck_publish'
exec @cmd
IF @@ERROR <> 0
return (1)
if (select category & @tranpublish_bit from master.dbo.sysdatabases where name = @database collate database_default) <> 0
begin
select @cmd = N'update' + quotename(@database) + N'.dbo.syspublications set ad_guidname=NULL where name=N' + quotename(@name, N'''')
exec (@cmd)
end
if (select category & @mergepublish_bit from master.dbo.sysdatabases where name = @database collate database_default) <> 0
begin
select @cmd = N'update' + quotename(@database) + N'.dbo.sysmergepublications set ad_guidname=NULL where name=N' + quotename(@name, N'''')
exec (@cmd)
end