Share via


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

Mapping SQL Server 2000 System Tables to SQL Server 2005 System Views

Other Resources

Integration Services Tables
Backup and Restore Tables
Log Shipping Tables

Help and Information

Getting SQL Server 2005 Assistance