MSreplication_subscriptions (Transact-SQL)
Applies to:
SQL Server
The MSreplication_subscriptions table contains one row of replication information for each Distribution Agent servicing the local Subscriber database. This table is stored in the subscription database.
Column name | Data type | Description |
---|---|---|
publisher | sysname | The name of the Publisher. |
publisher_db | sysname | The name of the Publisher database. |
publication | sysname | The name of the publication. |
independent_agent | bit | Indicates whether there is a stand-alone Distribution Agent for this publication. |
subscription_type | int | The type of subscription: 0 = Push. 1 = Pull. 2 = Anonymous. |
distribution_agent | sysname | The name of the Distribution Agent. |
Time | smalldatetime | The time of the last update by Distribution Agent. |
description | nvarchar(255) | The description of the subscription. |
transaction_timestamp | varbinary(16) | Internal-use only. |
update_mode | tinyint | The type of update. |
agent_id | binary(16) | The ID of the agent. |
subscription_guid | binary(16) | The global identifier for the version of the subscription on the publication. |
subid | binary(16) | The global identifier for an anonymous subscription. |
immediate_sync | bit | Indicates whether synchronization files are created or re-created each time the Snapshot Agent runs. |
See Also
Replication Tables (Transact-SQL)
Replication Views (Transact-SQL)
sp_helpsubscription (Transact-SQL)
Feedback
https://aka.ms/ContentUserFeedback.
În curând: Pe parcursul anului 2024, vom elimina treptat Probleme legate de GitHub ca mecanism de feedback pentru conținut și îl vom înlocui cu un nou sistem de feedback. Pentru mai multe informații, consultați:Trimiteți și vizualizați feedback pentru