Use this statement to stop a subscription for a user to a publication.
TO publication-name [ ( subscription-value ) ]
FOR subscriber-id, ...
publication-name The name of the publication to which the user is being subscribed. This may include the owner of the publication.
subscription-value A string that is compared to the subscription expression of the publication. The value is required here because each subscriber may have more than one subscription to a publication.
subscriber-id The user ID of the subscriber to the publication. This user must have a subscription to the publication.
A SQL Remote subscription is said to be started when publication updates are being sent from the consolidated database to the remote database.
The STOP SUBSCRIPTION statement prevents any further messages being sent to the subscriber. The START SUBSCRIPTION statement is required to restart messages being sent to the subscriber. However, you should ensure that the subscription is properly synchronized before restarting: that no messages have been missed.
Must have DBA authority.
SQL/2003 Vendor extension.
The following statement stops the subscription of user SamS to the pub_contact publication.
STOP SUBSCRIPTION TO pub_contact FOR SamS;