Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Expand Minimize

IHsubscriptions (Transact-SQL)

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.

Community Additions

ADD
Show:
© 2015 Microsoft