Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.