Export (0) Print
Expand All
Expand Minimize

MSmerge_subscriptions

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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft