SQL Server 2005 2008 xp_cmdshell 恢复与禁用

最新推荐文章于 2021-01-19 17:03:29 发布

转载最新推荐文章于 2021-01-19 17:03:29 发布 · 3.3k 阅读

渗透测试技术研究专栏收录该内容

68 篇文章

订阅专栏

SQL Server 2005 2208 xp_cmdshell存储过程默认禁用了，用下面的语句可以打开和禁用。

--SQL语句开xp_cmdshell

-- 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 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