While administering a subscription server, you can cancel subscriptions to selected publications or articles.
The Manage Subscriptions dialog box appears, listing publication servers that are authorized to publish to this subscriber.
A list of that server's publications appears.
The server will be unsubscribed from the publication, including all the articles contained within that publication.
The server will be unsubscribed from that article.
Another way to stop replication while administering a subscription server is to change the server's subscription options. You can remove the authorization that allows a publication server to send publications to the subscription server, or you can remove the authorization that allows a destination database to subscribe to publications
The Replication-Subscribing dialog box appears.
The publication server can no longer publish to this subscription server.
Caution This does not stop transactions from being placed in the distribution database for this subscriber. To do that, first unsubscribe from the publication. This action should only be taken as an emergency measure, to stop unwanted data from being replicated to a subscription server.
The database is no longer a destination database and can no longer subscribe to replicated data.
Note This only affects future subscriptions.