Before you can delete either a publication or a subscription, you must first delete all the articles in the publication or subscription.
Before you can delete a publication, you must first delete all subscriptions that subscribe to that publication.
You must suspend the database connection before you delete a publication or subscription. See “Suspending and resuming database connections” for more information.
To delete a publication, use sp_droppub:
where pub_name is the name of the publication.
To delete a subscription, use sp_dropsub:
where sub_name is the name of the subscription.