ReplicationServer.UninstallDistributor Method

Uninstalls replication publishing and distribution on the currently connected instance of SQL Server.

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

Syntax

'Declaration
Public Sub UninstallDistributor ( _
    force As Boolean _
)
public void UninstallDistributor (
    bool force
)
public:
void UninstallDistributor (
    bool force
)
public void UninstallDistributor (
    boolean force
)
public function UninstallDistributor (
    force : boolean
)

Parameters

  • force
    A Boolean value that specifies whether or not replication objects are removed from the server, even if a remote Distributor cannot be reached. If true, the publishing and Distributor configuration at the current server is uninstalled regardless of whether or not dependent publishing and distribution objects are uninstalled. If false, all dependent publishing and distribution objects are dropped before the Distributor is uninstalled.

Remarks

Before calling UninstallDistributor, you must first perform the following tasks:

  1. Delete all subscriptions. For more information, see How to: Delete a Push Subscription (RMO Programming) and How to: Delete a Pull Subscription (RMO Programming).

  2. Delete all publications. For more information, see How to: Delete a Publication (RMO Programming).

  3. Drop any distribution databases. For more information, see How to: Disable Publishing and Distribution (RMO Programming).

The UninstallDistributor method can only be called by members of the sysadmin fixed server role.

The UninstallDistributor method is equivalent to executing the sp_dropdistributor (Transact-SQL) stored procedure.

This namespace, class, or member is supported only in version 2.0 of the .NET Framework.

Example

myDist.UninstallDistributor(false);

Thread Safety

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

Platforms

Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Target Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

See Also

Reference

ReplicationServer Class
ReplicationServer Members
Microsoft.SqlServer.Replication Namespace