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.
|