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
0条评论