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.

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