Export (0) Print
Expand All

DistributionArticle Class

Represents information about an article published in a transactional or snapshot publication stored at the Distributor.

Object
  Microsoft.SqlServer.Replication.ReplicationObject
    Microsoft.SqlServer.Replication.DistributionArticle

Namespace:  Microsoft.SqlServer.Replication
Assembly:  Microsoft.SqlServer.Rmo (in Microsoft.SqlServer.Rmo.dll)

public sealed class DistributionArticle : ReplicationObject

The DistributionArticle type exposes the following members.

  NameDescription
Public methodDistributionArticle()Creates a new instance of the DistributionArticle class.
Public methodDistributionArticle(String, String, String, String, String, ServerConnection)Creates a new instance of the DistributionArticle class with the required properties and a connection to the Distributor.
Top

  NameDescription
Public propertyArticleIdGets or sets the ID value for the article.
Public propertyCachePropertyChangesGets or sets whether to cache changes made to the replication properties or to apply them immediately. (Inherited from ReplicationObject.)
Public propertyConnectionContextGets or sets the connection to an instance of Microsoft SQL Server. (Inherited from ReplicationObject.)
Public propertyDescriptionGets or sets a description for the article.
Public propertyDistributionDBNameGets or sets the name of the distribution database that contains the article metadata.
Public propertyIsExistingObjectGets whether the object exists on the server or not. (Inherited from ReplicationObject.)
Public propertyNameGets or sets the name of the article.
Public propertyPublicationDBNameGets or sets the name of the publication database.
Public propertyPublicationNameGets or sets the name of the publication that contains the article.
Public propertyPublisherNameGets or sets the name of the Publisher.
Public propertySourceObjectNameGets or sets the database object that provides the article data.
Public propertySourceObjectOwnerGets or sets the owner of the database object that provides the article data.
Public propertySqlServerNameGets the name of the Microsoft SQL Server instance to which this object is connected. (Inherited from ReplicationObject.)
Public propertyUserDataGets or sets an object property that allows users to attach their own data to the object. (Inherited from ReplicationObject.)
Top

  NameDescription
Public methodCommitPropertyChangesSends all the cached property change statements to the instance of Microsoft SQL Server. (Inherited from ReplicationObject.)
Public methodCreateCreates the article metadata at the Distributor.
Public methodDecoupleDecouples the referenced replication object from the server. (Inherited from ReplicationObject.)
Public methodEquals (Inherited from Object.)
Public methodGetHashCode (Inherited from Object.)
Public methodGetType (Inherited from Object.)
Public methodLoadLoads the properties of an existing object from the server. (Inherited from ReplicationObject.)
Public methodLoadPropertiesLoads the properties of an existing object from the server. (Inherited from ReplicationObject.)
Public methodRefreshReloads the properties of the object. (Inherited from ReplicationObject.)
Public methodRemoveRemoves article metadata from the Distributor.
Public methodScriptGenerates a Transact-SQL script that can be used to create or delete the article with the specified properties.
Public methodToString (Inherited from Object.)
Top

The DistributionArticle class is used primarily by SQL Server Management Studio and for non-SQL Server Publishers. To create, view, or modify the properties of an article, you should instead use an instance of the TransArticle class.

The DistributionArticle class requires a connection to the Distributor.

Thread Safety

Any public static (Shared in Microsoft Visual Basic) members of this type are safe for multithreaded operations. Any instance members are not guaranteed to be thread safe.

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Community Additions

ADD
Show:
© 2014 Microsoft