MSsubscriptions (Transact-SQL)
Applies to:
SQL Server
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. |
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 (Transact-SQL)
Replication Views (Transact-SQL)
sp_helpsubscription (Transact-SQL)
प्रतिक्रिया
https://aka.ms/ContentUserFeedback.
जल्द आ रहा है: 2024 के दौरान हम सामग्री के लिए फीडबैक तंत्र के रूप में GitHub मुद्दों को चरणबद्ध तरीके से समाप्त कर देंगे और इसे एक नई फीडबैक प्रणाली से बदल देंगे. अधिक जानकारी के लिए, देखें:के लिए प्रतिक्रिया सबमिट करें और देखें