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.
.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)