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.