The command(s) completed successfully. 備註 產生的xp_cmdshellWindows 進程具有與 SQL Server 服務帳戶相同的安全性許可權。 警告 xp_cmdshell是功能強大的功能,預設為停用。xp_cmdshell您可以使用原則式管理或執行sp_configure來啟用和停用。 如需詳細資訊,請參閱Surface area configurationandxp_cmdshell (server con...
Se aplica a: SQL ServerGenera un shell de comandos de Windows y lo pasa a una cadena para ejecutarlo. Los resultados se devuelven como filas de texto.Convenciones de sintaxis de Transact-SQLSintaxissyntaxsql Copiar xp_cmdshell { 'command_string' } [ , NO_OUTPUT ] Argumentos...
Enabling xp_cmdshell in SQL Server 2005 If you don't enable xp_cmdshell and you issue a command such as the following to get a directory listing of the C: drive: xp_cmdshell 'dir c:\' you get the following error message: Msg 15281, Level 16, State 1, Procedure xp_cmdshell, Line 1...
xp_cmdshell. You can also grant execute permission of it to other users. With the execution permission of xp_cmdshell, the user can execute any operating-system command at Microsoft Windows NT command shell that the account running Microsoft SQL Server has the needed privileges to ...
SQL Server 阻止了对组件'xp_cmdshell' 的过程'sys.xp_cmdshell' 的访问,因为此组件已作为此服务器安全配置的一部分而被关闭。系统管理员可以通过使用sp_configure 启用'xp_cmdshell'。有关启用'xp_cmdshell' 的详细信息,请参阅SQL Server 联机丛书中的"外围应用配置器"。
开发者在线 本文关键词: SQL Server 导入导出 bcp exec xp_cmdshell BCP是SQL Server中负责导入导出数据的一个命令行工具,它是基于DB-Library的,并且能以并行的方式高效地导入导出大批量的数据。BCP可以将数据库的表或视图直接导出,也能通过SELECT FROM语句对表或视图进行过滤后导出。在导入导出数据时,可以使用默认...
Applies to: SQL Server Spawns a Windows command shell and passes in a string for execution. Any output is returned as rows of text. Transact-SQL syntax conventions Syntax syntaxsql Copy xp_cmdshell { 'command_string' } [ , NO_OUTPUT ] Arguments 'command_string' The string that cont...
Applies to:SQL Server Spawns a Windows command shell and passes in a string for execution. Any output is returned as rows of text. Transact-SQL syntax conventions Syntax syntaxsqlCopy xp_cmdshell{'command_string'} [ ,NO_OUTPUT] Arguments ...
Applies to:SQL Server Spawns a Windows command shell and passes in a string for execution. Any output is returned as rows of text. Transact-SQL syntax conventions Syntax syntaxsql xp_cmdshell{'command_string'} [ ,NO_OUTPUT] Arguments
Applies to: SQL Server Spawns a Windows command shell and passes in a string for execution. Any output is returned as rows of text. Transact-SQL syntax conventions Syntax syntaxsql Copy xp_cmdshell { 'command_string' } [ , NO_OUTPUT ] Arguments Important Arguments for extended stored ...