sysmergesubscriptions (Transact-SQL)
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: 10 = SQL Server 7.0. 20 = SQL Server 7.0 Service Pack (SP) 1. 30 = SQL Server 7.0 SP2 35 = Service Broker SP3 40 = SQL Server 2000 50 = SQL Server 2000 SP1 55 = SQL Server 2000 SP2 60 = SQL Server 2000 SP3 90 = SQL Server 2005 100 = SQL Server 2008 |
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. |