STOP SUBSCRIPTION statement [SQL Remote]

Stops 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 starts 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. Ensure that the subscription is properly synchronized before restarting: that no messages have been missed.

Privileges

You must have the SYS_REPLICATION_ADMIN_ROLE system role.

Side effects

Automatic commit.

Standards

ANSI/ISO SQL Standard
Not in the standard.

Example

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

STOP SUBSCRIPTION TO pub_contact
FOR Sam_Singer;