IHextendedSubscriptionView (Transact-SQL)
The IHextendedSubscriptionView view exposes information on subscription to a non-SQL Server publication. This view is stored in the distribution database.
Column name |
Data type |
Description |
|---|---|---|
article_id |
int |
The unique identifier for an article. |
dest_db |
sysname |
The name of the destination database. |
srvid |
smallint |
The unique identifier for a Subscriber. |
login_name |
sysname |
The login used for connecting to a Subscriber. |
distribution_jobid |
binary |
Identifies the Distribution Agent job. |
publisher_database_id |
int |
Identifies the publication database. |
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. |
sync_type |
tinyint |
The type of initial synchronization: 1 = Automatic 2 = None |
status |
tinyint |
The status of the subscription: 0 = Inactive 1 = Subscribed 2 = Active |
snapshot_seqno_flag |
bit |
Indicates if a snapshot sequence number is being used. |
independent_agent |
bit |
Specifies whether there is a stand-alone Distribution Agent for this publication. 0 = The publication uses a shared Distribution Agent, and each Publisher database/Subscriber database pair has a single, shared Agent. 1 = There is a stand-alone Distribution Agent for this publication. |
subscription_time |
datetime |
Internal use only. |
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: 1 = Does not send back. 0 = Sends back. |
agent_id |
int |
The unique identifier of the Distribution Agent. |
update_mode |
tinyint |
Indicates the type of updating mode, which can be one of the following: 0 = Read-only. 1 = Immediate update. 2 = Queued update using Message Queuing. 3 = Immediate update with queued update as failover using Message Queuing. 4 = Queued update using SQL Server queue. 5 = immediate update with queued update failover, using SQL Server queue. |
publisher_seqno |
varbinary(16) |
The sequence number of the transaction at the Publisher for this subscription. |
ss_cplt_seqno |
varbinary(16) |
The sequence number used to signify the completion of the concurrent snapshot processing. |
See Also
Reference
Replication Views (Transact-SQL)