Metadata information for primary articles includes:
Database server name and database name of the primary database
Publication name
Owner of the primary object
Name of the primary object
Stored procedure group number (stored procedures only)
Type of the primary object (table or stored procedure)
Number of replicate articles that subscribe to the primary article
Shadow table name
To get metadata information about a specific primary
article
Use sp_helpprimaryart with the info keyword, and specify the primary article:
sp_helpprimaryart info, pri_art
where pri_art is the name of the primary article.
The sp_helpprimaryart procedure allows you to qualify a primary article by publication or by primary database.
To get metadata information about a specific primary
article in a specific publication
Use sp_helpprimaryart with the info keyword, and specify a primary article name and a publication:
sp_helpprimaryart info, pri_art, pub=pub_name
where pri_art is the name of the primary article, and pub_name is the name of a publication.
To get metadata information about a specific primary
article in a specific primary database
Use sp_helpprimaryart with the info keyword, and specify a primary article name and a primary database connection:
sp_helpprimaryart info, 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.
To get metadata information about all primary
articles
Use sp_helpprimaryart with no keyword:
sp_helpprimaryart
