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 = SQL Server 7.0 SP3 40 = SQL Server 2000 50 = SQL Server 2000 SP1 55 = SQL Server 2000 SP2 60 = SQL Server 2000 SP3 90 = SQL Server 2005 |
|
supportability_mode |
int |
Internal use only. |
|
application_name |
nvarchar(128) |
Internal use only. |
|
subscriber_number |
int |
Internal use only. |
