sp_helpreplicateart

Description

Returns information about replicate articles.

Syntax

sp_helpreplicateart [info]
sp_helpreplicateart info, rep_art [, {conn=conn_name|sub=sub_name}]
sp_helpreplicateart fields, rep_art, {conn=conn_name|sub=sub_name}

Parameters

info

is a keyword that requests information about all replicate articles in all replicate databases, or information about a specified replicate article in a specified replicate database or subscription.

fields

is a keyword that requests field information for a specified replicate article in a specified replicate database or subscription.

rep_art

is the name of a replicate article. Replicate article names can be specified in the form owner.name.

conn=conn_name

is a label identifying a replicate database connection. The connection name (conn_name) must be specified in the form ds.db, where:

sub=sub_name

is a label identifying a subscription.

Examples

Example 1

sp_helpreplicateart

Returns information about all replicate articles in all replicate database connections.

NoteUsing sp_helpreplicateart with no keyword is functionally identical to specifying only the info keyword.

Example 2

sp_helpreplicateart @rep_art=table1

Returns information about all replicate articles named table1 in all replicate databases. This is functionally identical to Example 3.

Example 3

sp_helpreplicateart fields, table1, "conn=boulder.doc"

Returns field information about the replicate article table1 in the replicate database doc on the data server boulder.

Example 4

sp_helpreplicateart fields, "joe.table1", "sub=subdoc"

Returns field information about the replicate article table1 with owner joe in the subscription subdoc.

Usage

See also

sp_helpprimaryart, sp_helpreplicateconn, sp_helpsub