EnumThirdPartyPublications2 Method
В будущей версии Microsoft SQL Server эта возможность будет удалена. Избегайте использования этой возможности в новых разработках и запланируйте изменение существующих приложений, в которых она применяется.
The EnumThirdPartyPublications2 method returns a QueryResults object that enumerates publications originating from heterogeneous data sources.
Синтаксис
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. |
Замечания
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.
.gif "Примечание") Примечание |
|---|
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. |