Creates a new publication for a specified primary database connection.
sp_addpub pub_name, conn_name
is the name of the new publication.
is the name of a primary database connection. Connection names must be specified in the form ds.db, where:
ds is the name of the data server on which the primary database resides.
db is the name of the primary database.
sp_addpub pubdoc, "boulder.doc"
Creates a new publication named pubdoc for the primary connection to the database doc on the data server boulder.
Before you invoke sp_addpub, you must suspend the database connection using sp_suspendprimaryconn. After the publication is created, you can resume the database connection with sp_resumeprimaryconn.
The single quote (or apostrophe) character is not allowed in a publication name. For example, the publication name pub’s is not allowed.
To publish a primary object, after you create a publication, you must create at least one primary article in that publication with sp_addprimaryart.
When the requested action occurs successfully, no results are returned.
When an error occurs, an error message is returned.
sp_addprimaryart, sp_addprimaryconn, sp_addsub, sp_helpprimaryart, sp_helpprimaryconn, sp_helppub