STOP SUBSCRIPTION statement [SQL Remote]

Use this statement to stop a subscription for a user to a publication.

Syntax
STOP SUBSCRIPTION
TO publication-name [ ( subscription-value ) ]
FOR subscriber-id, ...
Parameters
  • 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.

Remarks

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.

Permissions

Must have DBA authority.

Side effects

Automatic commit.

See also
Standards and compatibility
  • SQL/2003   Vendor extension.

Example

The following statement stops the subscription of user SamS to the pub_contact publication.

STOP SUBSCRIPTION TO pub_contact
FOR SamS;