sql server 2008如何打开和禁用xp_cmdshell

最新推荐文章于 2025-06-02 09:43:19 发布

原创最新推荐文章于 2025-06-02 09:43:19 发布 · 7.6k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#sql server 2008 #xp_cmdsehll

数据库专栏收录该内容

33 篇文章

订阅专栏

本文将指导您如何配置SQL Server中的高级特性和功能，包括启用XP CMDShell和高级选项，以及如何进行启用与禁用操作。

-- 打开
EXEC sp_configure 'show advanced options', 1
GO
-- To update the currently configured value for advanced options.
RECONFIGURE
GO
-- To enable the feature.
EXEC sp_configure 'xp_cmdshell', 1
GO
-- To update the currently configured value for this feature.
RECONFIGURE
GO
-- To disallow advanced options to be changed.
EXEC sp_configure 'show advanced options', 0
GO
-- To update the currently configured value for advanced options.
RECONFIGURE
GO

--如果要禁用，

-- To allow advanced options to be changed.
EXEC sp_configure 'show advanced options', 1
GO
-- To update the currently configured value for advanced options.
RECONFIGURE
GO
-- To disable the feature.
EXEC sp_configure 'xp_cmdshell', 0
GO
-- To update the currently configured value for this feature.
RECONFIGURE
GO

-- To disallow advanced options to be changed.
EXEC sp_configure 'show advanced options', 0
GO
-- To update the currently configured value for advanced options.
RECONFIGURE
GO