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)