SQLServer.RemoteServer Object
Lists subscriptions to the specified article on a remote server. List is returned in a QueryResults object.
QueryResults = RemoteServer.EnumSubscriptions (
[DatabaseName :=] idPubDatabase,
[PublicationName :=] idPublication,
[ArticleName :=] idArticle )
HRESULT pRemoteServer->EnumSubscriptions (
SQLOLE_LPCSTR idPubDatabase,
SQLOLE_LPCSTR idPublication,
SQLOLE_LPCSTR idArticle,
LPSQLOLEQUERYRESULTS* ppQueryResults );
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 |
ColumnName | ColumnType |
---|
subscriber | SQLOLE_DTypeChar |
publication | SQLOLE_DTypeChar |
article | SQLOLE_DTypeChar |
destination database | SQLOLE_DTypeChar |
subscription status | SQLOLE_DTypeInt1 |
synchronization type | SQLOLE_DTypeInt1 |
sp_helpsubscription