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 nameData typeDescription
publisher_idsmallintThe ID of the Publisher.
publisher_dbsysnameThe name of the Publisher database.
publication_idintThe ID of the publication.
subscriber_idsmallintThe ID of the Subscriber.
subscriber_dbsysnameThe name of the subscription database.
subscription_typeintThe type of subscription:

0 = Push.

1 = Pull.

2 = Anonymous.
sync_typetinyintThe type of synchronization:

1 = Automatic.

2 = No sync.
statustinyintThe status of the subscription.
subscription_timedatetimeThe time the subscription was added.

Replication Tables (Transact-SQL)
Replication Views (Transact-SQL)

Community Additions