UnSubscribe Method

SQLServer.RemoteServer Object

Description

Stops an existing subscription from a remote server.

Visual Basic

RemoteServer.UnSubscribe (
[DatabaseName :=] idPubDatabase,
[[PublicationName :=] idPublication,]
[[ArticleName :=] idArticle] )

C++

HRESULT pRemoteServer->UnSubscribe (
SQLOLE_LPCSTR idPubDatabase,
SQLOLE_LPCSTR idPublication = NULL,
SQLOLE_LPCSTR idArticle = NULL );

Elements

Element Type Description

idPubDatabase Identifier Database on the remote server that is publishing the article.
idPublication Identifier Publication that contains the article. Default is all publications.
idArticle Identifier Article in publication to unsubscribe from. Default is all articles.

Reference

sp_unsubscribe