Jaa


DistributionArticle Object

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 DistributionArticle object exposes the properties of a Distributor's image of a replicated article.

SQL-DMO object model that shows the current object

Properties

ID Property

SourceObjectName Property

Name Property

SourceObjectOwner Property

Methods

BeginAlter Method

DoAlter Method

CancelAlter Method

Remove Method (Objects)

Remarks

For snapshot and transactional replication, a replication Distributor maintains an image of the published article. The Distributor replicates the article image to Subscribers, enabling one type of replication load balancing.

There is no requirement that an instance of Microsoft SQL Server 2000 create the Distributor-maintained data image. Snapshot and transactional replication publications created on the Distributor enable one type of third-party, or heterogeneous, replication.

With the DistributionArticle object, you can:

  • Create an article in a heterogeneous replication publication.
  • Remove an article from a heterogeneous replication publication.

Note

The DistributionArticle object is compatible with instances SQL Server version 7.0 and later. However, the DistributionArticle2 object extends the functionality of the DistributionArticle object for use with features that were introduced in SQL Server 2000.

See Also

Reference

DistributionArticle2 Object

Help and Information

Getting SQL Server 2005 Assistance