SQLServer.RemoteServer Object
Lists the articles contained in the specified publication and database for a remote server. List is returned in a QueryResults object.
QueryResults = RemoteServer.EnumArticles (
[DatabaseName :=] idPubDatabase,
[PublicationName :=] idPublication )
HRESULT pRemoteServer->EnumArticles (
SQLOLE_LPCSTR idPubDatabase,
SQLOLE_LPCSTR idPublication,
LPSQLOLEQUERYRESULTS* ppQueryResults );
| Element | Type | Description |
|---|
| QueryResults | QueryResults | Returned QueryResults object |
| idPubDatabase | Identifier | Database on the remote server that contains the publication |
| idPublication | Identifier | Publication that contains the articles to list |
| ColumnName | ColumnType |
|---|
| article id | SQLOLE_DTypeInt4 |
| article name | SQLOLE_DTypeChar |
| base table | SQLOLE_DTypeChar |
| destination table | SQLOLE_DTypeChar |
| synchronization object | SQLOLE_DTypeChar |
| type | SQLOLE_DTypeInt1 |
| status | SQLOLE_DTypeInt1 |
| filter | SQLOLE_DTypeChar |
| description | SQLOLE_DTypeChar |
| insert_command | SQLOLE_DTypeChar |
| update_command | SQLOLE_DTypeChar |
| delete_command | SQLOLE_DTypeChar |
| creation script path | SQLOLE_DTypeChar |
| vertical partition | SQLOLE_DTypeBit |
| pre_creation_cmd | SQLOLE_DTypeInt1 |
| filter_clause | SQLOLE_DTypeText |