SQLServer.RemoteServer Object
Executes a Transact-SQL statement on a remote server. Returns results in a QueryResults object.
QueryResults = RemoteServer.ExecuteWithResults ( [Command :=] strSQLStatement )
HRESULT pRemoteServer->ExecuteWithResults (
SQLOLE_LPCSTR strSQLStatement,
LPSQLOLEQUERYRESULTS* ppQueryResults );
| Element | Type | Description |
|---|
| QueryResults | QueryResults | Returned QueryResults object |
| strSQLStatement | String | SQL statement |
The contents of the QueryResults object depend on the Transact-SQL statement.
sp_sqlexec