다음을 통해 공유

  • 아티클

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.