Cacher is the code snippet organizer for pro developers

declare @packageId uniqueidentifier
declare PackageRemoval cursor for

--**** Collect package Guids
select Guid
from vRM_Package_Item
where Name in (
       'Antivirus Inventory Package component'
       ,'Intel SCS 5.5.0.3 - Software Package Resource'
       ,'Intel® SCS package'
       ,'OOB Site Server Configuration Package' 
       ,'OOB Site Server Inventory Package' 
       ,'OOB Site Service Agent - Software Package Resource' 
       ,'Out of Band Discovery Package' 
       ,'Out of Band Site Service Agent package' 
       ,'Out of Band Task Plug-in Package' 
       ,'Symantec Endpoint Protection Uninstall Management' 
) 
or Name like '%Pluggable Protocols%' 

--******************* 

open PackageRemoval 
	fetch next from PackageRemoval into @packageId 
	while @@FETCH_STATUS = 0 
		begin 
			update RM_ResourceSoftware_Package set Attributes = 0 where Guid = @packageId 
			update RM_ResourcePackage set Attributes = 0 where Guid = @packageId 
			delete from SWDPackageServer where PackageId = @packageId 
			delete from SWDPackageCodebase where PackageId = @packageId 
			delete from Evt_AeX_Package_Server_Package_Event where PackageId = @packageId 
			delete from Evt_NS_Scheduled_Event where ItemGuid = @packageId 
			delete from ItemSchedule where ItemGuid = @packageId -- Uncomment if the package is broken. 
			insert into ItemToDelete  
			select @packageId, GETDATE () 
			fetch next from PackageRemoval into @packageId 
		end 
close PackageRemoval 
deallocate PackageRemoval