sql2005 如何禁用xp_cmdshell

发布网友发布时间：2022-04-10 00:34

共2个回答

热心网友时间：2022-04-10 02:03

在查询分析器里执行

---启用
-- 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 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', 0
GO
-- To update the currently configured value for this feature.
RECONFIGURE
GO

热心网友时间：2022-04-10 03:21

你不能删除这些系统存储过程。
可以*数据库用户使用这些存储过程即可