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

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 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.


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.

Community Additions