Returns information about publications.
sp_helppub [info|empty]
sp_helppub {info|arts|unsub}, pub_name
is a keyword that requests information for all publications or for the specified publication.
is a keyword that requests information about all empty publications (publications with no articles) in all primary database connections.
is a keyword that requests information about all primary articles in the specified publication.
is a keyword that requests information about all primary articles in the specified publication, for which there are no subscribers.
is the name of a publication.
sp_helppub
Returns information about all publications for all primary database connections.
Using sp_helppub with no
keyword is functionally identical to specifying only the info keyword.
sp_helppub info, pubdoc
Returns information about the publication pubdoc.
sp_helppub unsub, pubdoc
Returns information about all primary articles for which there are no subscribers in the publication pubdoc.
When listing information about publications, the following result set is returned:
Column |
Datatype |
Description |
|---|---|---|
ds |
sysname |
Name of the local primary data server |
db |
sysname |
Name of the local primary database |
pub_name |
sysname |
Publication name |
When listing information about primary articles in publications, the following result set is returned:
Column |
Datatype |
Description |
|---|---|---|
ds |
sysname |
Name of the local primary data server. |
db |
sysname |
Name of the local primary database. |
pub_name |
sysname |
Publication name. |
owner |
sysname |
Owner of primary article. |
part_name |
sysname |
Name of primary article. |
proc_num |
smallint |
Stored procedure group number. If only one procedure exists, then proc_num=1. Tables are proc_num=0. |
art_type |
varchar(9) |
Type of article:
|
numsubscribers |
int |
Number of replicate articles that subscribe to this primary article. |
shadow_table |
sysname |
Name of the shadow table for this primary article. |
When sp_helppub is invoked with no keyword, it returns information about all publications for all primary database connections.
When you invoke sp_helppub and specify the info keyword, the publication name (pub_name) is optional.
When you invoke sp_helppub and specify the empty keyword, you cannot specify a publication name (pub_name).
When you invoke sp_helppub and specify the arts or unsub keyword, the publication name (pub_name) is required.
When an error occurs, an error message is returned.
sp_helpprimaryart, sp_helpprimaryconn, sp_helpsub
