共用方式為


ReplicationServer.UninstallDistributor 方法

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

命名空間:  Microsoft.SqlServer.Replication
組件:  Microsoft.SqlServer.Rmo (在 Microsoft.SqlServer.Rmo.dll 中)

語法

'宣告
Public Sub UninstallDistributor ( _
    force As Boolean _
)
'用途
Dim instance As ReplicationServer 
Dim force As Boolean

instance.UninstallDistributor(force)
public void UninstallDistributor(
    bool force
)
public:
void UninstallDistributor(
    bool force
)
member UninstallDistributor : 
        force:bool -> unit
public function UninstallDistributor(
    force : boolean
)

參數

  • force
    型別:System.Boolean
    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.

備註

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

  1. Delete all subscriptions. For more information, see 如何:刪除發送訂閱 (RMO 程式設計) and 如何:刪除提取訂閱 (RMO 程式設計).

  2. Delete all publications. For more information, see 如何:刪除發行集 (RMO 程式設計).

  3. Drop any distribution databases. For more information, see 如何:停用發行和散發 (RMO 程式設計).

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.

範例

myDist.UninstallDistributor(false);

請參閱

參考

ReplicationServer 類別

Microsoft.SqlServer.Replication 命名空間