IHextendedSubscriptionView (Transact-SQL)


Applies To: SQL Server

The IHextendedSubscriptionView view exposes information on subscription to a non-SQL Server publication. This view is stored in the distribution database.

Column nameData typeDescription
article_idintThe unique identifier for an article.
dest_dbsysnameThe name of the destination database.
srvidsmallintThe unique identifier for a Subscriber.
login_namesysnameThe login used for connecting to a Subscriber.
distribution_jobidbinaryIdentifies the Distribution Agent job.
publisher_database_idintIdentifies the publication database.
subscription_typeintThe type of subscription:

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

 1 = Pull - the distribution agent runs at the Distributor.
sync_typetinyintThe type of initial synchronization:

 1 = Automatic

 2 = None
statustinyintThe status of the subscription:

 0 = Inactive

 1 = Subscribed

 2 = Active
snapshot_seqno_flagbitIndicates if a snapshot sequence number is being used.
independent_agentbitSpecifies 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_timedatetimeInternal use only.
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:

 1 = Does not send back.

 0 = Sends back.
agent_idintThe unique identifier of the Distribution Agent.
update_modetinyintIndicates 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_seqnovarbinary(16)The sequence number of the transaction at the Publisher for this subscription.
ss_cplt_seqnovarbinary(16)The sequence number used to signify the completion of the concurrent snapshot processing.

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

Community Additions