共用方式為

DisableTransSubscription Method

  • 發行項

未來的 Microsoft SQL Server 發行版本將不再提供此功能。請避免在新的開發工作中使用此功能，並計劃修改目前使用此功能的應用程式。

The DisableTransSubscription method removes the record of a Subscriber-initiated (pull) subscription from the transactional or snapshot publication Publisher and Distributor.

語法

object
.DisableTransSubscription(
Subscriber
,
SubscriptionDatabase
,
Publication
)

Parts

  • object
    Expression that evaluates to an object in the Applies To list.
  • Subscriber
    String that specifies an existing Subscriber by name.
  • SubscriptionDatabase
    String that specifies the subscribed database by name.
  • Publication
    String that specifies an existing transactional or snapshot replication publication by name.

Prototype (C/C++)

HRESULT DisableTransSubscription(
SQLDMO_LPCSTR Subscriber,
SQLDMO_LPCSTR SubscriptionDatabase,
SQLDMO_LPCSTR Publication);

備註

Removing a pull subscription by using SQL Distributed Management Objects (SQL-DMO) is a two-step process. The application must remove the subscription at the Subscriber, and then separately remove the record of the subscription at the Publisher and Distributor.

To remove a pull subscription to a transactional or snapshot replication publication

  1. Establish a SQLServer object connection to the Subscriber.

  2. Extract the TransPullSubscription object referencing the subscription from the Subscriber TransPullSubscriptions collection.

  3. Use the Remove method of the TransPullSubscription object.

  4. Establish a SQLServer object connection to the Publisher.

  5. Use the DisableTransSubscription method of the ReplicationDatabase object referencing the published database.

Applies To:

ReplicationDatabase Object