Collapse the table of content
Expand the table of content


SQL Server 2000

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 ID of the Publisher.
publisher_db sysname Name of the Publisher database.
publication_id int ID of the publication.
subscriber_id smallint ID of the Subscriber.
subscriber_db sysname Name of the subscription database.
subscription_type int Type of subscription:

0 = Push
1 = Pull
2 = Anonymous

sync_type tinyint Type of synchronization:

1 = Automatic
2 = No sync

status tinyint Status of the subscription.
subscription_time datetime Time the subscription was added.

© 2016 Microsoft