How to: Delete a Push Subscription (SQL Server Management Studio)

Delete a push subscription at the Publisher (from the Local Publications folder in Microsoft SQL Server Management Studio) or the Subscriber (from the Local Subscriptions folder). Deleting a subscription does not remove objects or data from the subscription; they must be removed manually.

To delete a push subscription at the Publisher

1. Connect to the Publisher in SQL Server Management Studio, and then expand the server node.

2. Expand the Replication folder, and then expand the Local Publications folder.

3. Expand the publication associated with the subscription you want to delete.

4. Right-click the subscription, and then click Delete.

5. In the confirmation dialog box, select whether to connect to the Subscriber to delete subscription information. If you clear the Connect to Subscriber checkbox, you should connect to the Subscriber later to delete the information.

To delete a push subscription at the Subscriber

1. Connect to the Subscriber in SQL Server Management Studio, and then expand the server node.

2. Expand the Replication folder, and then expand the Local Subscriptions folder.

3. Right-click the subscription you want to delete, and then click Delete.

4. In the confirmation dialog box, select whether to connect to the Publisher to delete subscription information. If you clear the Connect to Publisher check box, you should connect to the Publisher later to delete the information.

See Also

Concepts

Subscribing to Publications

Other Resources

How to: Delete a Push Subscription (Replication Transact-SQL Programming)

Help and Information

Getting SQL Server 2005 Assistance