syssubscriptions (Transact-SQL)

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

Contains one row for each subscription in the database. This table is stored in the publication database.

Column name Data type Description
artid int The unique ID of an article.
srvid smallint The server ID of the Subscriber.
dest_db sysname The name of the destination 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 adding the subscription.
subscription_type int The type of subscription:

0 = Push - the distribution agent runs at the Distributor.

1 = Pull - the distribution agent runs at the Subscriber.
distribution_jobid binary(16) The job ID of the Distribution Agent.
timestamp timestamp The timestamp.
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 The type of subscription initialization:

0 = automatic (snapshot)

1 = replication support only

2 = initialize with backup

3 = initialize from log sequence number (LSN)

For more information, see the @sync_type parameter of sp_addsubscription.
srvname sysname The name of the Subscriber.

See Also

Replication Tables (Transact-SQL)
Replication Views (Transact-SQL)