The CommandShellWithResults method returns a QueryResults object enumerating execution output from an operating system command executed on the server running Microsoft® SQL Server™.
object.CommandShellWithResults( Command ) as QueryResults
| Part | Description |
|---|---|
| object | Expression that evaluates to an object in the Applies To list |
| Command | Operating system command string |
A QueryResults object containing one result set defined by this value
| Column name | Data type | Description |
|---|---|---|
| output | varchar(512) | First 512 characters of a line of text generated by operating system command execution. |
SQL Server implements secure access to the operating system through a number of security mechanisms. For more information about configuring access to the operating system, see xp_cmdshell.
HRESULT CommandShellWithResults(
SQLDMO_LPCSTR Command,
LPSQLDMOQUERYRESULTS* ppResults);