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