How to delete publications and articles (Enterprise Manager)

How to delete publications and articles (Enterprise Manager)

To delete a publication

• At the Publisher, open SQL Server Enterprise Manager, expand a server group, expand the Replication folder, expand the Publications folder, right-click the publication, and then click Delete.

To delete an article

Note  Deleting articles from publications that have subscriptions is not allowed. To delete an article, you must first delete all subscriptions to the publication.

1. At the Publisher, open SQL Server Enterprise Manager, expand a server group, expand the Replication folder, expand the Publications folder, right-click the publication, and then click Properties.
   
   
2. Click the Articles tab, select an article to delete, and then clear the check box next to the article to delete.