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.

See Also

Reference

Replication Views (Transact-SQL)

Concepts

Replication Tables (Transact-SQL)