syssubscriptions (Transact-SQL)
Contains one row for each subscription in the database. This table is stored in the publication database.
| Column name | Data type | Description |
|---|---|---|
artid |
int |
The unique ID of an article. |
srvid |
smallint |
The server ID of the Subscriber. |
dest_db |
sysname |
The name of the destination database. |
status |
tinyint |
The status of the subscription: 0 = Inactive. 1 = Subscribed. 2 = Active. |
sync_type |
tinyint |
The type of initial synchronization: 1 = Automatic. 2 = None |
login_name |
sysname |
The login name used when adding the subscription. |
subscription_type |
int |
The type of subscription: 0 = Push - the distribution agent runs at the Subscriber. 1 = Pull - the distribution agent runs at the Distributor. |
distribution_jobid |
binary(16) |
The job ID of the Distribution Agent. |
timestamp |
timestamp |
The timestamp. |
update_mode |
tinyint |
The update mode: 0 = Read only. 1 = Immediate-updating. |
loopback_detection |
bit |
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. |
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 reinitialization. |
nosync_type |
tinyint |
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. |
srvname |
sysname |
The name of the Subscriber. |
See Also
Reference
Mapping SQL Server 2000 System Tables to SQL Server 2005 System Views
Other Resources
Integration Services Tables
Backup and Restore Tables
Log Shipping Tables
Help and Information
Getting SQL Server 2005 Assistance
Change History
| Release | History |
|---|---|
15 September 2007 |
|