The EnumThirdPartyPublications method returns a QueryResults object enumerating publications originating from heterogenous data sources.
object.EnumThirdPartyPublications( [ DistributionDBName ])
as QueryResults
| Part | Description |
|---|---|
| object | Expression that evaluates to an object in the Applies To list. |
| DistributionDBName | Optional. String identifying an existing Microsoft® SQL Server™ replication distribution database by name. When specified, restricts result set membership to those publications implemented in the named database. |
A QueryResults object containing one result set defined by these columns.
| Column | Data type | Description |
|---|---|---|
| publisher_db | nvarchar(129) | Name of database published. |
| publication | nvarchar(129) | Publication name. |
| replication_type | tinyint | Replication method. Interpret the value by using SQLDMO_REPLICATION_ TYPE. |
| immediate_sync | bit | When True, force immediate synchronization on publication subscription. |
| allow_pull | bit | When True, allow Subscriber-originated (pull) subscriptions. |
| allow_anonymous | bit | When True, allow anonymous, pull subscriptions. |
| enabled_for_internet | bit | When True, publication is enabled for distribution by using the Internet. |
| repl_freq | tinyint | Frequency used to replicate data. Interpret value by using SQLDMO_ REPFREQ_TYPE. |
| immediate_sync_ready | bit | When True, a synchronizing image of the publication is allowed. |
| allow_sync_tran | bit | When True, allow Subscriber to update article image and propagate the update to the Publisher. |
| independent_agent | bit | When True, a stand-alone agent enables the publication. |
| agent_access | bit | Reserved. |
| thirdparty_flag | bit | When True, the publication derives from a heterogeneous source. |
| vendor_name | nvarchar(129) | Data source vendor name. |
| publisher | nvarchar(129) | Data source name. |
| description | nvarchar(256) | Descriptive text. |
| distribution_db | nvarchar(129) | Distribution database name. |
HRESULT EnumThirdPartyPublications(
LPSQLDMOQUERYRESULTS *ppResults,
LPCTSTR DistributionDBName = NULL);