EnumSubscriptions List

SQLServer.RemoteServer Object

Description

Lists subscriptions to the specified article on a remote server. List is returned in a QueryResults object.

Visual Basic

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

C++

HRESULT pRemoteServer->EnumSubscriptions (
SQLOLE_LPCSTR
idPubDatabase,
SQLOLE_LPCSTR
idPublication,
SQLOLE_LPCSTR
idArticle,
LPSQLOLEQUERYRESULTS*
ppQueryResults );

Elements

Element Type Description

QueryResults QueryResults Returned QueryResults object
idPubDatabase Identifier Database on the remote server that is publishing the article
idPublication Identifier Publication that contains the article
idArticle Identifier Article

QueryResults

ColumnName ColumnType

subscriber SQLOLE_DTypeChar
publication SQLOLE_DTypeChar
article SQLOLE_DTypeChar
destination database SQLOLE_DTypeChar
subscription status SQLOLE_DTypeInt1
synchronization type SQLOLE_DTypeInt1

Reference

sp_helpsubscription