The EnumSubscriptions method returns a QueryResults object enumerating the subscriptions to a replication publication.
| MergePublication Object | TransPublication Object |
object.EnumSubscriptions() as QueryResults
| Part | Description |
|---|---|
| object | Expression that evaluates to an object in the Applies To list |
For the MergePublication object, a QueryResults object containing one result set defined by these columns.
| Column | Data type | Description |
|---|---|---|
| subscription_name | nvarchar(258) | Subscription name. |
| publication | nvarchar(129) | Publication name. |
| publisher | nvarchar(129) | Name of the publishing data source. |
| publisher_db | nvarchar(129) | Name of the database referenced by the publication. |
| subscriber | nvarchar(129) | Name of the subscribing data source. |
| subscriber_db | nvarchar(129) | Name of the subscribed database at the Subscriber. |
| status | integer | Subscription status. Interpret the value by using SQLDMO_SUBSTATUS_ TYPE. |
| subscriber_type | integer | Subscriber type. |
| subscription_type | integer | Subscription direction. Interpret the value by using SQLDMO_ SUBSCRIPTION_TYPE. |
| priority | single | Conflict resolution priority. |
| sync_type | tinyint | Type of synchronization used. Interpret the value by using SQLDMO_ SUBSYNC_TYPE. |
| description | nvarchar(256) | Descriptive text. |
| merge_jobid | binary(22) | Identifier of the SQL Server Agent job launching the replication agent. |
| full_publication | tinyint | Reserved. |
For the TransPublication object, a QueryResults object containing one result set defined by these columns.
| Column | Data type | Description |
|---|---|---|
| subscriber | nvarchar(129) | Name of the subscribing data source. |
| publication | nvarchar(129) | Publication name. |
| article | nvarchar(129) | When publication is not full, article subscribed to. |
| destination database | nvarchar(129) | Name of the subscribed database at the Subscriber. |
| subscription status | tinyint | Subscription status. Interpret the value by using SQLDMO_SUBSTATUS_ TYPE. |
| synchronization type | tinyint | Type of synchronization used. Interpret the value by using SQLDMO_ SUBSYNC_TYPE. |
| subscription type | integer | Subscription direction. Interpret the value by using SQLDMO_ SUBSCRIPTION_TYPE. |
| full subscription | bit | When True, subscription subscribes to all articles defined in the publication. |
| subscription_name | nvarchar(256) | Subscription name. |
| update mode | integer | When 0, the subscription is read-only. When 1, updates to article images maintained at the Subscriber are propagated to the Publisher. |
| distribution job id | binary(22) | Identifier of the SQL Server Agent job launching the replication agent. |
| loopback_detection | bit | When True, Distributor sends Subscriber-originated transactions back to originating Subscriber. |
HRESULT EnumSubscriptions(LPSQLDMOQUERYRESULTS* ppResults);