后续版本的 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
Establish a SQLServer object connection to the Subscriber.
Extract the TransPullSubscription object referencing the subscription from the Subscriber TransPullSubscriptions collection.
Use the Remove method of the TransPullSubscription object.
Establish a SQLServer object connection to the Publisher.
Use the DisableTransSubscription method of the ReplicationDatabase object referencing the published database.