You can get the following information about primary articles in publications:
All publications in all primary databases that contain a primary article with a specified name
All publications in a specific primary database that contain a primary article with a specified name
All primary articles in a specified publication or in a specified primary database
The sp_helpprimaryart procedure returns information about publications that contain a specified primary article.
To get information about publications that contain a specific primary article, use sp_helpprimaryart with the pubs keyword and specify a primary article:
sp_helpprimaryart pubs, pri_art
where pri_art is the name of the primary article.
To get information about publications in a specific primary database that contain a specific primary article, use sp_helpprimaryart with the pubs keyword and specify a primary article name and a primary database connection:
sp_helpprimaryart pubs, pri_art, conn="conn_name"
where pri_art is the name of the primary article, and conn_name is the name of a primary database connection.
The sp_helppub procedure returns information about primary articles in a specified publication.
To get information about all primary articles in a specified publication, use sp_helppub with the arts keyword and specify a publication:
sp_helppub arts, pub_name
where pub_name is the name of a publication.
The sp_helpprimaryconn procedure returns information about primary articles and unpublished primary objects in a primary database.
To get information about all primary articles in all publications in a specific primary database, use sp_helpprimaryconn with the arts keyword and specify a primary database connection:
sp_helpprimaryconn arts, conn="conn_name"
where conn_name is the name of a primary database connection.
