Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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. |
See Also
Concepts
Replication Tables (Transact-SQL)