syssubscriptions (System View) (Transact-SQL)

syssubscriptions (System View) (Transact-SQL)


Applies To: SQL Server

The syssubscriptions view exposes subscription information. This view is stored in the distribution database.

Column nameData typeDescription
artidintThe unique ID of a subscribed article.
srvidsmallintThe server ID of the Subscriber.
dest_dbsysnameThe name of the subscription database.
statustinyintThe status of the subscription:

 0 = Inactive.

 1 = Subscribed.

 2 = Active.
sync_typetinyintThe type of initial synchronization:

 1 = Automatic.

 2 = None.
login_namesysnameThe login name used when connecting to the Publisher to add the subscription.
subscription_typeintThe type of subscription:

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

 1 = Pull - the distribution agent runs at the Subscriber.
distribution_jobidbinary(16)Identifies the Distribution Agent job used to synchronize the subscription.
timestmaptimestampThe date and time that the subscription was created.
update_modetinyintThe update mode:

 0 = Read-only.

 1 = Immediate-updating.
loopback_detectionbitApplies 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_reinitbitSpecifies 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_typetinyintThe 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.

 3 = Identified for informational purposes only. Not supported. Future compatibility is not guaranteed.
srvnamesysnameThe name of the Subscriber.

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

Community Additions

© 2016 Microsoft