There may be a very simple way to recover by xiaolu see here http://666w.com/art/732.htm such as future expansion storage process is deleted: Delete drop PROCEDURE sp_addextendedprocdrop PROCEDURE sp_OAcreateexec sp_dropextendedproc 'xp_cmdshell' recovery dbcc addextendedproc ( "sp_OAcreate" "ODSOLE70.DLL") DBCC AddExtendedProc ("XP_CMDSHELL", "XPLOG70.DLL") This can be recovered directly, no need to deperse sp_addeXtendedProc exist :) More DBCC command excavations.