MSsubscriptions (Transact-SQL)

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

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 (8.x). 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

Replication Tables
Replication Views
sp_helpsubscription (Transact-SQL)