How to drop all subscriptions to a publication (Enterprise Manager)

How to Install SQL Server 2000

How To

How to drop all subscriptions to a publication (Enterprise Manager)

  1. On the Subscriptions tab, click the subscription name, and then click Delete.

  2. Click OK to close the Publication Properties dialog box, and then reopen it in the Create and Manage Publications dialog box by clicking Properties & Subscriptions.

  3. In the Publication Properties dialog box, click the Filter Rows tab, and then complete the WHERE clause using a user-defined function as part of the filter condition.