DistributionArticle Object
The DistributionArticle object exposes the properties of a Distributor's image of a replicated article.
Properties
| Description Property | SourceObjectName Property |
| ID Property | SourceObjectOwner Property |
| Name 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.
For more information about using SQL-DMO in heterogeneous replication, see Programming Snapshot or Transactional Replication from Heterogeneous Data Sources.
Note The DistributionArticle object is compatible with instances of SQL Server 2000 and SQL Server version 7.0. However, the DistributionArticle2 object extends the functionality of the DistributionArticle object for use with features that are new in SQL Server 2000.