T-SQL实现xp_cmdshell 开启与关闭

--启用xp_cmdshell

USE master

GO
EXEC sp_configure 'show advanced options', 1

GO
RECONFIGURE WITH OVERRIDE

GO
EXEC sp_configure 'xp_cmdshell', 1

GO
RECONFIGURE WITH OVERRIDE

GO
EXEC sp_configure   'show advanced options', 0

GO
RECONFIGURE WITH OVERRIDE

GO 

 

--关闭xp_cmdshell 
USE master

GO
EXEC sp_configure 'show advanced options', 1

GO
RECONFIGURE WITH OVERRIDE

GO
EXEC sp_configure 'xp_cmdshell', 0

GO
RECONFIGURE WITH OVERRIDE

GO
EXEC sp_configure   'show advanced options', 0

GO
RECONFIGURE WITH OVERRIDE

GO