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 |
| sync_type | tinyint | Type of synchronization:
1 = Automatic |
| login_name | sysname | Login name used when adding the subscription |
| subscription_type | int | Type of subscription:
0 = Push |
| distribution_jobid | binary(16) | Job ID of the Distribution Agent |
| timestamp | timestamp | Timestamp |
| update_mode | tinyint | Update mode:
0 = Read only |
| loopback_detection | bit | Whether the Distribution Agent sends transactions originated at the Subscriber back to the Subscriber:
True = Does not send 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. |