Delete and restore extended stored procedure xp_cmdshell statement removes an extended stored procedure xp_cmdshell statement: exec sp_dropextendedproc 'xp_cmdshell' recovery cmdshell SQL statement EXEC sp_addextendedproc xp_cmdshell, @ dllname = 'xplog70.dll'
Open the SQL statement of cmdshell
EXEC SP_ADDEXTENDEDPROC XP_CMDSHELL, @ DLLNAME = 'XPLOG70.DLL'
Judging whether the storage extension exists as a select count (*) from master.dbo.sysobjects where xtype = 'x' and name = 'xp_cmdshell' return result is 1 OK
Recovery xp_cmdshellExec master.dbo.addextendedproc 'xp_cmdshell', 'xplog70.dll'; select count (*) from master.dbo.sysobjects where xtype = 'X' and name = 'xp_cmdshell' returns a value of 1 to OK
Otherwise, Upload XPLog7.0.dllexec Master.dbo.addextendedProc 'XP_Cmdshell', 'C: /Winnt/System32/XPLOG70.DLL'
SQL statement sp_dropextendedProc "xp_cmdshell" plugged in cmdshell
