MSmerge_subscriptions (Transact-SQL)
Applies to: 
SQL Server
The MSmerge_subscriptions table contains one row for each subscription serviced by the Merge Agent at the Subscriber. This table is stored in the distribution database.
| Column name | Data type | Description |
|---|---|---|
| publisher_id | smallint | The ID of the Publisher. |
| publisher_db | sysname | The name of the Publisher database. |
| publication_id | int | The ID of the publication. |
| subscriber_id | smallint | The ID of the Subscriber. |
| subscriber_db | sysname | The name of the subscription database. |
| subscription_type | int | The type of subscription: 0 = Push. 1 = Pull. 2 = Anonymous. |
| sync_type | tinyint | The type of synchronization: 1 = Automatic. 2 = No sync. |
| status | tinyint | This column is no longer in use. To check the status of a merge subscription, review the status column in the sysmergesubscriptions table in the publication or subscription database. |
| subscription_time | datetime | The time the subscription was added. |
See Also
Replication Tables (Transact-SQL)
Replication Views (Transact-SQL)
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for