|
Starts a subscription for a user to a publication.
START SUBSCRIPTION TO publication-name [ ( subscription-value ) ] FOR subscriber-id, ...
The name of the publication to which the user is being subscribed. This may include the owner of the publication.
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.
The user ID of the subscriber to the publication. This user must have a subscription to the publication.
A SQL Remote subscription starts when publication updates are being sent from the consolidated database to the remote database.
The START SUBSCRIPTION statement is one of a set of statements that manage subscriptions. The CREATE SUBSCRIPTION statement defines the data that the subscriber is to receive. The SYNCHRONIZE SUBSCRIPTION statement ensures that the consolidated and remote databases are consistent with each other. The START SUBSCRIPTION statement is required to start messages being sent to the subscriber.
Data at each end of the subscription must be consistent before a subscription is started. Use the database extraction utility to manage the creation, synchronization, and starting of subscriptions. If you use the database extraction utility, you do not need to execute an explicit START SUBSCRIPTION statement. Also, the Message Agent starts subscriptions once they are synchronized.
You must have the SYS_REPLICATION_ADMIN_ROLE system role.
Automatic commit.
Not in the standard.
The following statement starts the subscription of user Sam_Singer to the pub_contact publication.
START SUBSCRIPTION TO pub_contact FOR Sam_Singer;