IHsubscriptions (Transact-SQL)

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

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.


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)