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