EnumThirdPartyPublications Method
Questa caratteristica verrà rimossa a partire da una delle prossime versioni di Microsoft SQL Server. Evitare di utilizzare questa funzionalità in un nuovo progetto di sviluppo e prevedere interventi di modifica nelle applicazioni in cui è attualmente implementata.
The EnumThirdPartyPublications method returns a QueryResults object that enumerates publications originating from heterogenous data sources.
Sintassi
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. |
Osservazioni
The EnumThirdPartyPublications2 method extends the functionality of the EnumThirdPartyPublications method.