MSmerge_subscriptions (T-SQL)

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.

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.