Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
The MSsubscriptions table contains one row for each published article in a subscription serviced by the local Distributor. This table is stored in the distribution database.
Column name |
Data type |
Description |
|---|---|---|
publisher_database_id |
int |
The ID of the Publisher database. |
publisher_id |
smallint |
The ID of the Publisher. |
publisher_db |
sysname |
The name of the Publisher database. |
publication_id |
int |
The ID of the publication. |
article_id |
int |
The ID of the article. |
subscriber_id |
smallint |
The ID of the Subscriber. |
subscriber_db |
sysname |
The name of the subscription database. |
subscription_type |
int |
The type of subscription: 0 = Push. 1 = Pull. 2 = Anonymous. |
sync_type |
tinyint |
The type of synchronization: 1 = Automatic. 2 = No synchronization. |
status |
tinyint |
The status of the subscription: 0 = Inactive. 1 = Subscribed. 2 = Active. |
subscription_seqno |
varbinary(16) |
The snapshot transaction sequence number. |
snapshot_seqno_flag |
bit |
Indicates the source of the snapshot transaction sequence number, where a value of 1 means that subscription_seqno is the snapshot sequence number. |
independent_agent |
bit |
Indicates whether 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. Note This column is supported only for backward compatibility with the bi-directional replication functionality in SQL Server 2000. For later versions of SQL Server, peer-to-peer replication should be used instead. For more information, see Peer-to-Peer Transactional Replication. |
agent_id |
int |
The ID of the agent. |
update_mode |
tinyint |
The type of update. |
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
sp_helpsubscription (Transact-SQL)