Export (0) Print
Expand All
Expand Minimize
0 out of 1 rated this helpful - Rate this topic

MSmerge_subscriptions (Transact-SQL)

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

The status of the subscription.

subscription_time

datetime

The time the subscription was added.

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.