syssubscriptions

Transact-SQL Reference

previous page next page
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.

previous page start next page