syssubscriptions (System View) (Transact-SQL)
The syssubscriptions view exposes subscription information. This view is stored in the distribution database.
| Column name | Data type | Description |
|---|---|---|
artid |
int |
The unique ID of a subscribed article. |
srvid |
smallint |
The server ID of the Subscriber. |
dest_db |
sysname |
The name of the subscription database. |
status |
tinyint |
The status of the subscription: 0 = Inactive. 1 = Subscribed. 2 = Active. |
sync_type |
tinyint |
The type of initial synchronization: 1 = Automatic. 2 = None. |
login_name |
sysname |
The login name used when connecting to the Publisher to add the subscription. |
subscription_type |
int |
The type of subscription: 0 = Push - the distribution agent runs at the Subscriber. 1 = Pull - the distribution agent runs at the Distributor. |
distribution_jobid |
binary(16) |
Identifies the Distribution Agent job used to synchronize the subscription. |
timestmap |
timestamp |
The date and time that the subscription was created. |
update_mode |
tinyint |
The update mode: 0 = Read-only. 1 = Immediate-updating. |
loopback_detection |
bit |
Applies to subscriptions that are part of a bidirectional transactional replication topology. Loopback detection determines whether the Distribution Agent sends transactions originated at the Subscriber back to the Subscriber: 0 = Sends back. 1 = Does not send back. |
queued_reinit |
bit |
Specifies whether the article is marked for initialization or reinitialization. A value of 1 specifies that the subscribed article is marked for initialization or reinitialization. |
nosync_type |
tinyint |
Specifies the type of initialization when sync_type = 2, and can be one of the following values: 0 = none - Subscriber already has the schema and initial data for published tables. This option has been deprecated. 1 = replication support only - provides automatic generation at the Subscriber of article custom stored procedures and triggers that support updating subscriptions. Assumes that Subscriber already has the schema and initial data for published tables. 2 = initialize with backup - Schema and initial data for published tables are obtained from a backup of the publication database. Assumes that the Subscriber has access to a backup of the publication database. 3 = For internal use only. |
See Also
Reference
Replication Views (Transact-SQL)
syssubscriptions (Transact-SQL)
Concepts
Replication Tables (Transact-SQL)