Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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)