EnumThirdPartyPublications2 Method

Esse recurso será removido em uma versão futura do Microsoft SQL Server. Evite usar esse recurso em desenvolvimentos novos e planeje modificar os aplicativos que atualmente o utilizam.

The EnumThirdPartyPublications2 method returns a QueryResults object that enumerates publications originating from heterogeneous data sources.

Sintaxe

object.EnumThirdPartyPublications2( 
[ bstrDistributionDBName ] , 
[ bstrVendorName ])asQueryResults

Parts

• object
  Expression that evaluates to an object in the Applies To list.

• bstrDistributionDBName
  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.

• bstrVendorName
  Optional. String used to filter the result set by vendor name.

Prototype (C/C++)

HRESULT EnumThirdPartyPublications2(
LPSQLDMOQUERYRESULTS *ppResults, 
SQLDMO_LPCSTR pszDistributionDBName, 
SQLDMO_LPCSTR pszVendorName);

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 (pull) subscriptions that originate at the Subscriber.
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 the published database
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(100)	Name of vendor whose application created the publication.

Comentários

An application can call the EnumThirdPartyVendorNames method to retrieve a distinct list of third-party vendor names. By specifying a specific vendor name in the bstrVendorName parameter, the application could then call EnumThirdPartyPublications2 method to enumerate publications created by that vendor.

If bstrVendorName is set to 'others' only third-party publications where the vendor_name column contains NULL or is empty are returned.

Observação

If an application calls EnumThirdPartyPublications2 on an instance of SQL Server version 7.0 and the bstrVendorName parameter is not NULL, the constant, SQLDMO_E_SQL80ONLY, and the message "This property or method requires Microsoft SQL Server 2000 or later" are returned. EnumThirdPartyPublications2 can be used with SQL Server 7.0 and Microsoft SQL Server 2000 or later if the bstrVendorName parameter is NULL.

Applies To:

Distributor2 Object

Consulte também

Referência

EnumThirdPartyPublications Method