EnumThirdPartyPublications Method

SQL-DMO

SQL-DMO

EnumThirdPartyPublications Method

The EnumThirdPartyPublications method returns a QueryResults object that enumerates publications originating from heterogenous data sources.

Applies To
Distributor Object
Syntax

object.EnumThirdPartyPublications( [ DistributionDBName ] )
as QueryResults

Parts

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.

Prototype (C/C++)

HRESULT EnumThirdPartyPublications(
LPSQLDMOQUERYRESULTS *ppResults,
SQLDMO_LPCSTR pszDistributionDBName);

Returns

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.

Remarks

The EnumThirdPartyPublications2 method extends the functionality of the EnumThirdPartyPublications method.

See Also

EnumThirdPartyPublications2 Method