sysmergesubscriptions (Transact-SQL)
Applies to:
SQL Server
Contains one row for each known Subscriber and is a local table at the Publisher. This table is stored in the publication and subscription databases.
Column name | Data type | Description |
---|---|---|
subscriber_server | sysname | The ID of the server. Used to map the srvid field to the server-specific value when migrating a copy of the subscription database to a different server. |
db_name | sysname | The name of the subscribing database. |
pubid | uniqueidentifier | The ID of the publication from which the current subscription was created. |
datasource_type | int | The type of data source: 0 = Microsoft SQL Server. 2 = Jet OLE DB. |
subid | uniqueidentifier | The unique identification number for Subscription. |
replnickname | binary | The compressed nickname for the replica. |
replicastate | uniqueidentifier | A unique identifier that is used to determine if the previous synchronization was successful by comparing the value at the Publisher with the value at the Subscriber. |
status | tinyint | The status of the subscription: 0 = Inactive. 1 = Active. 2 = Deleted. |
subscriber_type | int | The type of Subscriber: 1 = Global. 2 = Local. 3 = Anonymous. |
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. |
description | nvarchar(255) | A brief description of the subscription. |
priority | real | Specifies the subscription priority and allows the implementation of priority-based conflict resolution. Equals 0.00 for all local or anonymous subscriptions. |
recgen | bigint | The number of the last generation received. |
recguid | uniqueidentifier | The unique ID of the last generation received. |
sentgen | bigint | Number of the last generation sent. |
sentguid | uniqueidentifier | The unique ID of the last generation sent. |
schemaversion | int | The number of the last schema received. |
schemaguid | uniqueidentifier | The unique ID of the last schema received. |
last_validated | datetime | The datetime of the last successful validation of Subscriber data. |
attempted_validate | datetime | The last datetime that validation was attempted on the subscription. |
last_sync_date | datetime | The datetime of the synchronization. |
last_sync_status | int | The subscription status: 0 = All jobs are waiting to start. 1 = One or more jobs are starting. 2 = All jobs have executed successfully. 3 = At least one job is executing. 4 = All jobs are scheduled and idle. 5 = At least one job is attempting to execute after a previous failure. 6 = At least one job has failed to execute successfully. |
last_sync_summary | sysname | The description of last synchronization results. |
metadatacleanuptime | datetime | The last datetime that expired metadata was removed from merge replication system tables. |
partition_id | int | Identifies the pre-computed partition to which the subscription belongs. |
cleanedup_unsent_changes | bit | Identifies that metadata for unsent changes have been cleaned up at the Subscriber. |
replica_version | int | Identifies the version of SQL Server for the Subscriber to which the subscription belongs, which can be one of the following values: 90 = SQL Server 2005 (9.x) 100 = SQL Server 2008 (10.0.x) |
supportability_mode | int | Internal use only. |
application_name | nvarchar(128) | Internal use only. |
subscriber_number | int | Internal use only. |
last_makegeneration_datetime | datetime | The last datetime that the makegeneration process ran for the Publisher. For more information, see the -MakeGenerationInterval parameter in Replication Merge Agent. |
last_local_sentgen | bigint | Stores the last generation that was sent by the previous merge agent sync. |
last_local_recguid | uniqueidentifier | Stores the last local received generation GUID from previous merge agent sync. |
last_local_recgen | bigint | Set by merge cleanup. Stores the last local generation received. |
See Also
Opinia
https://aka.ms/ContentUserFeedback.
Dostępne już wkrótce: W 2024 r. będziemy stopniowo wycofywać zgłoszenia z serwisu GitHub jako mechanizm przesyłania opinii na temat zawartości i zastępować go nowym systemem opinii. Aby uzyskać więcej informacji, sprawdź:Prześlij i wyświetl opinię dla