Export (0) Print
Expand All

DistributionPublication Class

Represents information about a transactional or snapshot publication stored at the Distributor.

Object
  Microsoft.SqlServer.Replication.ReplicationObject
    Microsoft.SqlServer.Replication.DistributionPublication

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

public sealed class DistributionPublication : ReplicationObject

The DistributionPublication type exposes the following members.

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

  NameDescription
Public propertyAttributesGets or sets the publication attributes for the distribution publication.
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 publication.
Public propertyDistributionArticlesReturns information about the articles in the publication stored at the Distributor.
Public propertyDistributionDBNameGets or sets the name of the distribution database for the publication.
Public propertyDistributionSubscriptionsRepresents information about subscriptions to the publication stored at the Distributor.
Public propertyIsExistingObjectGets whether the object exists on the server or not. (Inherited from ReplicationObject.)
Public propertyLogReaderAgentGets or sets the name of the Log Reader Agent job for the transactional publication.
Public propertyNameGets or sets the name of the publication.
Public propertyPubIdGets the publication ID.
Public propertyPublicationDBNameGets or sets the name of the publication database.
Public propertyPublisherNameGets or sets the name of the Publisher.
Public propertySnapshotAgentGets or sets the name of the Snapshot Agent job for the transactional publication.
Public propertySqlServerNameGets the name of the Microsoft SQL Server instance to which this object is connected. (Inherited from ReplicationObject.)
Public propertyTypeGets or sets the type of replication for this publication.
Public propertyUserDataGets or sets an object property that allows users to attach their own data to the object. (Inherited from ReplicationObject.)
Public propertyVendorNameGets or sets the product manufacturer of the non-SQL Server Publisher of the publication.
Top

  NameDescription
Public methodCommitPropertyChangesSends all the cached property change statements to the instance of Microsoft SQL Server. (Inherited from ReplicationObject.)
Public methodCreateCreates the publication metadata at the Distributor.
Public methodDecoupleDecouples the referenced replication object from the server. (Inherited from ReplicationObject.)
Public methodEnumDistributionArticlesReturns information maintained at the Distributor on articles in this publication.
Public methodEnumDistributionSubscriptionsReturns information maintained at the Distributor for subscriptions to this publication.
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 metadata for the publication from the Distributor.
Public methodScriptGenerates a Transact-SQL script that can be used to create or remove the publication metadata at the Distributor.
Public methodToString (Inherited from Object.)
Top

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

The DistributionPublication 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.
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft