syssubscriptions (System View) (Transact-SQL)
The syssubscriptions view exposes subscription information. This view is stored in the distribution database.
The unique ID of a subscribed article.
The server ID of the Subscriber.
The name of the subscription database.
The status of the subscription:
0 = Inactive.
1 = Subscribed.
2 = Active.
The type of initial synchronization:
1 = Automatic.
2 = None.
The login name used when connecting to the Publisher to add the subscription.
The type of subscription:
0 = Push - the distribution agent runs at the Distributor.
1 = Pull - the distribution agent runs at the Subscriber.
Identifies the Distribution Agent job used to synchronize the subscription.
The date and time that the subscription was created.
The update mode:
0 = Read-only.
1 = Immediate-updating.
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.
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.
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.
3 = Identified for informational purposes only. Not supported. Future compatibility is not guaranteed.
The name of the Subscriber.