共用方式為


DropSubscription Method (Replication ActiveX)

The DropSubscription method drops the subscription having the specified control properties.

語法

object.DropSubscription DBDropOption
Part Description

object

Expression that evaluates to an object in the Applies To list.

DBDropOption

Option to drop; use a value from DBDROPOPTION (Replication ActiveX).

傳回值

Return code Description

S_OK

Method succeeded.

E_FAIL

General failure occurred. Check error records for detailed information.

REPLX_E_SUBNOTFOUND

Specified subscription does not exist.

REPLX_E_RETRYFAILURE

Failure occurred that might require retrying the last operation.

Applies To

SQLDistribution Object (Replication ActiveX)

SQLMerge Object (Replication ActiveX)

備註

Push subscriptions are not currently supported by this method.

The Initialize Method (Replication ActiveX) should not be called prior to using DropSubscription.

If DROP_DATABASE is specified, the database is dropped even when the subscription specified by the SubscriptionName Property (Replication ActiveX) property does not exist. Error notification is not provided.

DropSubscription also supports dropping the subscription without dropping the database.

In Microsoft Visual Basic, DropSubscription is a Sub method and does not return a value.

Prototype C/C++

HRESULT DropSubscription(
     DBDROPOPTION DBDropOption); 

請參閱

參考

AddSubscription Method (Replication ActiveX)
CopySubscription Method (Replication ActiveX)
DBDROPOPTION (Replication ActiveX)
SubscriptionName Property (Replication ActiveX)

說明及資訊

取得 SQL Server 2005 協助