SQLserver危险存储过程删除与恢复

SQL server数据库中危险存储过程的删除和恢复

SQL扩展的删除和恢复

delete
USE MASTER
EXECSP _ dropextendedProc ' XP _ cmdshell '
EXECSP _ dropextendedProc ' XP _ dirtree '
exec Sp _ dropextendedProc ' XP _ enum groups '
exec Sp _ dropextendedProc ' XP _ fixed drives '
exec Sp _ dropextendedProc ' XP _ loginconfig '
exec Sp _ dropextendedProc ' XP _ enu exec sp _ dropextendedproc ' Xp _ regdeletevalue '
exec sp _ dropextendedproc ' Xp _ regenumvalues '
exec sp _ dropextendedproc ' Xp _ regread '
exec sp _ dropextendedproc ' Xp _ regremovemultistring '
exec sp _ dropextendedproc ' Xp _ regwrite '
drop procedure sp _ make web task
go

restore
USE MASTER
EXECSP _ AddExtended proc XP _ CMDShell，' XP _ CMDShell . dll '
EXECSP _ AddExtended proc XP _ Dirtree，' XP star . dll '
exec sp _ AddExtended proc XP _ enum groups，' xplog 70 . dll '
exec sp _ AddExtended proc XP _ fixed drives，' XP star . dll '
exec sp _ AddExtended proc XP odsole 70 . dll '
exec sp _ addextendedproc XP _ regaddmultistring，' XP star . dll '
exec sp _ addextendedproc XP _ regdeletekey，' XP star . dll '
exec sp _ addextendedproc XP _ regdeletevalue，' XP star . dll '
exec sp _ addextendedproc XP _ regenumvalues，' XP star . dll '
exec sp _ addextendedproc XP _ regenumvalues