This topic has not yet been rated - Rate this topic

EnumThirdPartyPublications Method

SQL Server 2005

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

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

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.

Applies To:

Distributor Object

Reference

EnumThirdPartyPublications2 Method

Help and Information

Getting SQL Server 2005 Assistance

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD