others - 无法在Linux SQL Server 2017 Express 上启用 xp_cmdshell

我正在尝试在Linux RedHat 7.4上运行的SQL Server 2017 Express上启用xp_cmdshell

the specified option'xp_cmdshell'is not supported by this edition of SQL Server and cannot be changed using sp_configure.

是因为xp_cmdshell在Linux上不能工作,还是因为我使用的是免费的Express版?

谢谢!

时间: 原作者:

Linux上SQL Server 2017的版本和支持的功能-不支持的功能和服务

以下功能和服务不适用于Linux上的SQL Server 2017。


Area | Unsupported feature or service


------------------------------------------------------------------------------------


Database engine | Merge replication


 | Stretch DB


 | PolyBase


 | Distributed query with 3rd-party connections


 | Linked Servers to data sources other than SQL Server


 | System extended stored procedures (XP_CMDSHELL, etc.)


 | Filetable, FILESTREAM


 | CLR assemblies with the EXTERNAL_ACCESS or UNSAFE permission set


 | Buffer Pool Extension



注意“系统扩展的存储过程(XP_CMDSHELL等)"被列为不受支持。

以下功能和服务对SQL Server 2019在Linux上不可用,


 Area | Unsupported feature or service


 ---------------------------------------------------------------------------------------


 Database engine | Merge replication


 | Stretch DB


 | Distributed query with 3rd-party connections


 | Linked Servers to data sources other than SQL Server


 | System extended stored procedures (XP_CMDSHELL, etc.)


 | Filetable, FILESTREAM


 | CLR assemblies with the EXTERNAL_ACCESS or UNSAFE permission set


 | Buffer Pool Extension



原作者:
...