Contains one row for each subscription in the database. This table is stored in the master database and the published 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 |