Export (0) Print
Expand All
Expand Minimize

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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft