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