syssubscriptions

Transact-SQL Reference

Transact-SQL Reference

syssubscriptions

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

Column name Data type Description
artid int Unique ID of an article
srvid smallint Server ID of the Subscriber
dest_db sysname Name of the destination database
status tinyint Status:

0 = Inactive
1 = Subscribed
2 = Active

sync_type tinyint Type of synchronization:

1 = Automatic
2 = None

login_name sysname Login name used when adding the subscription
subscription_type int Type of subscription:

0 = Push
1 = Pull

distribution_jobid binary(16) Job ID of the Distribution Agent
timestamp timestamp Timestamp
update_mode tinyint Update mode:

0 = Read only
1 = Immediate-updating

loopback_detection bit Whether the Distribution Agent sends transactions originated at the Subscriber back to the Subscriber:

True = Does not send back
False = Sends 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 re-initialization.