STOP SUBSCRIPTION
TO publication-name [ ( subscription-value ) ]
FOR subscriber-id, ...

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.

DBA authority

Automatic commit.

• DROP SUBSCRIPTION statement [SQL Remote]
• START SUBSCRIPTION statement [SQL Remote]
• SYNCHRONIZE SUBSCRIPTION statement [SQL Remote]
• Extraction utility (dbxtract)
• Stopping subscriptions

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

STOP SUBSCRIPTION TO pub_contact
FOR SamS;