sysmergesubscriptions (Transact-SQL)

Applies to: SQL Server

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:

90 = SQL Server 2005 (9.x)

100 = SQL Server 2008 (10.0.x)
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.
last_local_sentgen bigint Stores the last generation that was sent by the previous merge agent sync.
last_local_recguid uniqueidentifier Stores the last local received generation GUID from previous merge agent sync.
last_local_recgen bigint Set by merge cleanup. Stores the last local generation received.

See Also

Replication Tables (Transact-SQL)