다음을 통해 공유


EnumThirdPartyPublications Method

Microsoft SQL Server의 이후 버전에서는 이 기능이 제거됩니다. 새 개발 작업에서는 이 기능을 사용하지 말고, 현재 이 기능을 사용하는 응용 프로그램은 수정하십시오.

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

구문

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.

주의

The EnumThirdPartyPublications2 method extends the functionality of the EnumThirdPartyPublications method.

Applies To:

Distributor Object

참고 항목

참조

EnumThirdPartyPublications2 Method

도움말 및 정보

SQL Server 2005 지원 받기