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