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.

Column nameData typeDescription
article_idintUniquely identifies a published article.
srvidsmallintThe server ID of the Subscriber.
dest_dbsysnameThe name of the destination database
login_namesysnameThe login name used when adding the subscription.
distribution_jobidbinary(16)The job ID of the Distribution Agent
timestamptimestampThe date and time that the subscription was created.
queued_reinitbitSpecifies whether the article is marked for initialization or reinitialization. A value of 1 specifies that the subscribed article is marked for initialization or reinitialization.
statustinyintThe status of the subscription:

 0 = Inactive.

 1 = Subscribed.

 2 = Active.
sync_typetinyintThe type of initial synchronization:

 1 = Automatic.

 2 = None.
subscription_typeintThe type of subscription:

 0 = Push - the distribution agent runs at the Subscriber.

 1 = Pull - the distribution agent runs at the Distributor.
update_modetinyintThe update mode:

 0 = Read-only.

 1 = Immediate-updating.
loopback_detectionbitApplies 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.

Heterogeneous Database Replication
Replication Tables (Transact-SQL)
Replication Views (Transact-SQL)
sp_addsubscription (Transact-SQL)
sp_helpsubscription (Transact-SQL)

Community Additions