ReplicationServer Members

  • Article

Represents an instance of Microsoft SQL Server that is involved in replication. It can take the role of Distributor, Publisher, Subscriber, or any combination of them.

The following tables list the members exposed by the ReplicationServer type.

Public Constructors

  Name Description
ReplicationServer Overloaded. Initializes a new instance of the ReplicationServer class.

Top

Public Properties

  Name Description
ms158280.pubproperty(en-US,SQL.90).gif AgentCheckupInterval Gets or sets the interval for the Distribution Agent to perform a checkup.
ms158280.pubproperty(en-US,SQL.90).gif CachePropertyChanges  Gets or sets whether to cache changes made to the replication properties or to apply them immediately. (inherited from ReplicationObject)
ms158280.pubproperty(en-US,SQL.90).gif ConnectionContext  Gets or sets the connection to an instance of Microsoft SQL Server. (inherited from ReplicationObject)
ms158280.pubproperty(en-US,SQL.90).gif DistributionDatabase Gets the name of the distribution database for the currently connected instance of SQL Server.
ms158280.pubproperty(en-US,SQL.90).gif DistributionDatabases Gets the distribution databases defined on the replication server.
ms158280.pubproperty(en-US,SQL.90).gif DistributionPublishers Gets the Publishers that use the currently connected instance of Microsoft SQL Server as a Distributor.
ms158280.pubproperty(en-US,SQL.90).gif DistributionServer Gets or sets the name of the Distributor for the currently connected instance of SQL Server.
ms158280.pubproperty(en-US,SQL.90).gif DistributorAvailable Gets whether the Distributor for the currently connected instance of Microsoft SQL Server is currently connected and available or not.
ms158280.pubproperty(en-US,SQL.90).gif DistributorInstalled Gets whether the currently connected instance of SQL Server has a local or remote Distributor.
ms158280.pubproperty(en-US,SQL.90).gif HasRemotePublisher Gets whether or not the currently connected instance of Microsoft SQL Server is a Distributor with a remote Publisher.
ms158280.pubproperty(en-US,SQL.90).gif IsDistributor Gets whether the currently connected instance of SQL Server is a Distributor or not.
ms158280.pubproperty(en-US,SQL.90).gif IsExistingObject  Gets whether the object exists on the server or not. (inherited from ReplicationObject)
ms158280.pubproperty(en-US,SQL.90).gif IsPublisher Gets whether or not the currently connected instance of Microsoft SQL Server is a Publisher.
ms158280.pubproperty(en-US,SQL.90).gif Name Gets the name of the instance of Microsoft SQL Server.
ms158280.pubproperty(en-US,SQL.90).gif RegisteredSubscribers Gets the Subscribers registered with the Publisher.
ms158280.pubproperty(en-US,SQL.90).gif ReplicationDatabases Gets the databases enabled for replication in the connected instance of Microsoft SQL Server.
ms158280.pubproperty(en-US,SQL.90).gif SqlServerName  Gets the name of the Microsoft SQL Server instance to which this object is connected. (inherited from ReplicationObject)
ms158280.pubproperty(en-US,SQL.90).gif UserData  Gets or sets an object property that allows users to attach their own data to the object. (inherited from ReplicationObject)
ms158280.pubproperty(en-US,SQL.90).gif WorkingDirectory Gets the working directory used by a Publisher.

Top

Public Methods

(see also Protected Methods )

  Name Description
ms158280.pubmethod(en-US,SQL.90).gif AttachSubscriptionDatabase Attaches a copied subscription database at the Subscriber.
ms158280.pubmethod(en-US,SQL.90).gif ChangeDistributorPassword Overloaded. Changes the Distributor password.
ms158280.pubmethod(en-US,SQL.90).gif ChangeReplicationServerPasswords Overloaded. Changes all stored instances of the password for a login maintained on the replication server.
ms158280.pubmethod(en-US,SQL.90).gif CommitPropertyChanges  Sends all the cached property change statements to the instance of Microsoft SQL Server. (inherited from ReplicationObject)
ms158280.pubmethod(en-US,SQL.90).gif CopySubscriptionDatabase Copies an existing pull subscription database.
ms158280.pubmethod(en-US,SQL.90).gif Decouple  Decouples the referenced replication object from the server. (inherited from ReplicationObject)
ms158280.pubmethod(en-US,SQL.90).gif EnumAgentProfiles Returns the replication agent performance profiles supported on the server.
ms158280.pubmethod(en-US,SQL.90).gif EnumBusinessLogicHandlers Returns the business logic handlers registered at the server.
ms158280.pubmethod(en-US,SQL.90).gif EnumCurrentPrincipals Returns information for all published databases that are participating in database mirroring.
ms158280.pubmethod(en-US,SQL.90).gif EnumCustomResolvers Returns all custom conflict resolvers registered on the connected instance of SQL Server.
ms158280.pubmethod(en-US,SQL.90).gif EnumDistributionDatabases Returns the distribution databases installed when the currently connected instance of Microsoft SQL Server is a Distributor.
ms158280.pubmethod(en-US,SQL.90).gif EnumDistributionPublishers Returns the Publishers using the currently connected instance of Microsoft SQL Server as their Distributor.
ms158280.pubmethod(en-US,SQL.90).gif EnumHeterogeneousColumns Returns the columns in a table on a non-SQL Server Publisher.
ms158280.pubmethod(en-US,SQL.90).gif EnumHeterogeneousTables Returns the available tables on a non-SQL Server Publisher.
ms158280.pubmethod(en-US,SQL.90).gif EnumLightPublications  
ms158280.pubmethod(en-US,SQL.90).gif EnumRegisteredSubscribers Returns the Subscribers that are registered at a Publisher.
ms158280.pubmethod(en-US,SQL.90).gif EnumReplicationDatabases Returns the databases enabled for replication.
ms158280.pubmethod(en-US,SQL.90).gif EnumSubscriberSubscriptions Returns the subscriptions on a Subscriber server.
ms158280.pubmethod(en-US,SQL.90).gif Equals  Overloaded. (inherited from Object )
ms158280.pubmethod(en-US,SQL.90).gif GetCurrentPrincipal Returns the current database mirroring principal for the specified publication database.
ms158280.pubmethod(en-US,SQL.90).gif GetHashCode  (inherited from Object )
ms158280.pubmethod(en-US,SQL.90).gif GetOriginalPublisher Returns the name of the originating Publisher for a published database participating in a database mirroring session.
ms158280.pubmethod(en-US,SQL.90).gif GetType  (inherited from Object )
ms158280.pubmethod(en-US,SQL.90).gif InstallDistributor Overloaded. Installs a Distributor.
ms158280.pubmethod(en-US,SQL.90).gif Load  Loads the properties of an existing object from the server. (inherited from ReplicationObject)
ms158280.pubmethod(en-US,SQL.90).gif LoadProperties  Loads the properties of an existing object from the server. (inherited from ReplicationObject)
ms158280.pubmethod(en-US,SQL.90).gifms158280.static(en-US,SQL.90).gif ReferenceEquals  (inherited from Object )
ms158280.pubmethod(en-US,SQL.90).gif Refresh  Reloads the properties of the object. (inherited from ReplicationObject)
ms158280.pubmethod(en-US,SQL.90).gif RegisterBusinessLogicHandler Registers a business logic handler assembly at the replication server.
ms158280.pubmethod(en-US,SQL.90).gif Script Returns a Transact-SQL script to install or uninstall replication on the server.
ms158280.pubmethod(en-US,SQL.90).gif ScriptInstallDistributor Returns a Transact-SQL script that installs the Distributor.
ms158280.pubmethod(en-US,SQL.90).gif ScriptUninstallDistributor Returns a Transact-SQL script that can be used to uninstall the Distributor.
ms158280.pubmethod(en-US,SQL.90).gif ToString  (inherited from Object )
ms158280.pubmethod(en-US,SQL.90).gif UninstallDistributor Uninstalls replication publishing and distribution on the currently connected instance of SQL Server.
ms158280.pubmethod(en-US,SQL.90).gif UnregisterBusinessLogicHandler Removes the registration for a business logic handler from a replication server.

Top

Protected Methods

  Name Description
ms158280.protmethod(en-US,SQL.90).gif CheckValidCreation  (inherited from ReplicationObject )
ms158280.protmethod(en-US,SQL.90).gif CheckValidDefinition  (inherited from ReplicationObject )
ms158280.protmethod(en-US,SQL.90).gif Finalize  (inherited from Object )
ms158280.protmethod(en-US,SQL.90).gif GetChangeCommand  (inherited from ReplicationObject )
ms158280.protmethod(en-US,SQL.90).gif GetCreateCommand  (inherited from ReplicationObject )
ms158280.protmethod(en-US,SQL.90).gif GetDropCommand  (inherited from ReplicationObject )
ms158280.protmethod(en-US,SQL.90).gif InternalRefresh  (inherited from ReplicationObject )
ms158280.protmethod(en-US,SQL.90).gif MemberwiseClone  (inherited from Object )

Top

See Also

Reference

ReplicationServer Class
Microsoft.SqlServer.Replication Namespace

Other Resources

How to: Configure Publishing and Distribution (RMO Programming)
How to: View and Modify Publisher and Distributor Properties (RMO Programming)
How to: Disable Publishing and Distribution (RMO Programming)
Replication Publishing Model Overview