Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
The IHsubscriptions system table contains one row for each subscription to a publication from a non-SQL Server Publisher using the current Distributor. This table is stored in the distribution database.
Definition
| Column name | Data type | Description |
|---|---|---|
article_id |
int |
Uniquely identifies a published article. |
srvid |
smallint |
The server ID of the Subscriber. |
dest_db |
sysname |
The name of the destination database |
login_name |
sysname |
The login name used when adding the subscription. |
distribution_jobid |
binary(16) |
The job ID of the Distribution Agent |
timestamp |
timestamp |
The date and time that the subscription was created. |
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. |
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. |
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. |
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. |
See Also
Reference
Replication Views (Transact-SQL)
sp_addsubscription (Transact-SQL)
sp_helpsubscription (Transact-SQL)
Concepts
Replication Tables (Transact-SQL)
Other Resources
Heterogeneous Database Replication