Anteckning
Åtkomst till den här sidan kräver auktorisering. Du kan prova att logga in eller ändra kataloger.
Åtkomst till den här sidan kräver auktorisering. Du kan prova att ändra kataloger.
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 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
Heterogeneous Database Replication
Replication Tables (Transact-SQL)
Replication Views (Transact-SQL)