sp_helpsub

Description

Returns information and statistics for subscriptions.

Syntax

sp_helpsub [info|stats|empty]
sp_helpsub {info|stats|arts|unsub}, sub_name 

Parameters

info

is a keyword that requests information for all subscriptions or for the specified subscription.

stats

is a keyword that requests statistics information for all subscriptions or for the specified subscription.

empty

is a keyword that requests information about all empty subscriptions (subscriptions with no articles) in all replicate database connections.

arts

is a keyword that requests information about all replicate articles in the specified subscription.

unsub

is a keyword that requests information about all primary articles in the corresponding publication for which there are no subscribers in the specified subscription.

sub_name

is the name of a subscription.

Examples

Example 1

sp_helpsub

Returns information about all subscriptions in all replicate database connections.

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

Example 2

sp_helpsub info, subdoc

Returns information about the subscription subdoc.

Example 3

sp_helpsub stats, subdoc

Returns statistics information for the subscription subdoc.

Usage

See also

sp_helppub, sp_helpreplicateart, sp_helpreplicateconn