IHsubscriptions (Transact-SQL)
Applies to: 
SQL Server
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
Heterogeneous Database Replication
Replication Tables (Transact-SQL)
Replication Views (Transact-SQL)
sp_addsubscription (Transact-SQL)
sp_helpsubscription (Transact-SQL)