CommandShellWithResults Method
The CommandShellWithResults method returns a QueryResults object enumerating execution output from an operating system command executed on an instance of Microsoft® SQL Server™ 2000.
Applies To
| SQLServer Object |
Syntax
object.CommandShellWithResults( Command ) as QueryResults
Parts
object
Expression that evaluates to an object in the Applies To list
Command
Operating system command string
Prototype (C/C++)
HRESULT CommandShellWithResults(
SQLDMO_LPCSTR Command,
LPSQLDMOQUERYRESULTS* ppResults);
Returns
A QueryResults object that contains 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 |
Remarks
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.