sp_addsub

Description

Creates a new subscription for a specified publication.

Syntax

sp_addsub sub_name, pub_name, conn_name

Parameters

sub_name

is the name of the new subscription.

pub_name

is the name of the publication to which the new subscription subscribes.

conn_name

is the name of a replicate database connection. Connection names must be specified in the form ds.db, where:

Examples

Example 1

sp_addsub subdoc, pubdoc, "boulder.doc"

Creates a new subscription named subdoc to the publication pubdoc, for the replicate connection to the database doc on the data server boulder.

Usage

See also

sp_addpub, sp_addreplicateart, sp_addreplicateconn, sp_helpreplicateart, sp_helpreplicateconn, sp_helpsub