MSsubscriptions (Transact-SQL)
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.
.gif "ms188368.note(en-US,SQL.90).gif")
Note:
This column is supported only for backward compatibility with the bi-directional replication functionality in SQL Server 2000. For SQL Server 2005, 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
Replication Views (Transact-SQL)
sp_helpsubscription (Transact-SQL)
Concepts
Replication Tables (Transact-SQL)