SQLServer.RemoteServer Object
Lists publications of the specified database on a remote server. List is returned in a QueryResults object.
QueryResults = RemoteServer.EnumPublications ( [DatabaseName :=] idPubDatabase )
HRESULT pRemoteServer->EnumPublications (
SQLOLE_LPCSTR idPubDatabase,
LPSQLOLEQUERYRESULTS* ppQueryResults );
| Element | Type | Description |
|---|
| QueryResults | QueryResults | Returned QueryResults object |
| idPubDatabase | Identifier | Database on the remote server that contains the publication |
| ColumnName | ColumnType |
|---|
| pubid | SQLOLE_DTypeInt4 |
| name | SQLOLE_DTypeChar |
| restricted | SQLOLE_DTypeBit |
| status | SQLOLE_DTypeInt1 |
| task | SQLOLE_DTypeInt4 |
| replication frequency | SQLOLE_DTypeInt1 |
| synchronization method | SQLOLE_DTypeInt1 |
| description | SQLOLE_DTypeChar |