USE [distribution]

SELECT * 
--delete
FROM MSsubscriptions


SELECT * 
--delete
FROM MSsubscriber_info
where subscriber like '%T09'

SELECT * 
--delete
FROM MSpublications


SELECT * 
FROM MSdistribution_agents
--where name like '%31'

SELECT * 
--delete
FROM MSsubscriber_schedule
where subscriber like '%T02'


SELECT * 
--delete
FROM MSdistribution_history