开启XP_CMDSHELL的多种方案

方法一

sp_configure 'show advanced options',1
reconfigure
go
sp_configure 'xp_cmdshell',1
reconfigure
go

方法二

sp_configure 'show advanced options',1
RECONFIGURE WITH OVERRIDE
go
sp_configure 'xp_cmdshell',1
RECONFIGURE WITH OVERRIDE
go

方法三

execute('exec..sp_configure ''show advanced options'',1') execute('reconfigure') execute('exec..sp_configure ''xp_cmdshell'',1') execute('reconfigure')--