删除SQL Server 2000的危险扩展

use master
exec sp_dropextendedproc xp_cmdshell
exec sp_dropextendedproc xp_dirtree
exec sp_dropextendedproc xp_enumgroups
exec sp_dropextendedproc xp_fixeddrives
exec sp_dropextendedproc xp_loginconfig
exec sp_dropextendedproc xp_enumerrorlogs
exec sp_dropextendedproc xp_getfiledetails

exec sp_dropextendedproc Sp_OACreate
exec sp_dropextendedproc Sp_OADestroy
exec sp_dropextendedproc Sp_OAGetErrorInfo
exec sp_dropextendedproc Sp_OAGetProperty
exec sp_dropextendedproc Sp_OAMethod
exec sp_dropextendedproc Sp_OASetProperty
exec sp_dropextendedproc Sp_OAStop

exec sp_dropextendedproc Xp_regaddmultistring
exec sp_dropextendedproc Xp_regdeletekey
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_makewebtask
go

 

假如你需要恢复,可以使用下面的脚本:

use master
exec sp_addextendedproc xp_cmdshell,"xp_cmdshell.dll "
exec sp_addextendedproc xp_dirtree,"xpstar.dll "
exec sp_addextendedproc xp_enumgroups,"xplog70.dll "
exec sp_addextendedproc xp_fixeddrives,"xpstar.dll "
exec sp_addextendedproc xp_loginconfig,"xplog70.dll "
exec sp_addextendedproc xp_enumerrorlogs,"xpstar.dll "
exec sp_addextendedproc xp_getfiledetails,"xpstar.dll "
exec sp_addextendedproc sp_OACreate,"odsole70.dll "
exec sp_addextendedproc sp_OADestroy,"odsole70.dll "
exec sp_addextendedproc sp_OAGetErrorInfo,"odsole70.dll "
exec sp_addextendedproc sp_OAGetProperty,"odsole70.dll"

 exec sp_addextendedproc sp_OAMethod,"odsole70.dll "
exec sp_addextendedproc sp_OASetProperty,"odsole70.dll "
exec sp_addextendedproc sp_OAStop,"odsole70.dll "
exec sp_addextendedproc xp_regaddmultistring,"xpstar.dll "
exec sp_addextendedproc xp_regdeletekey,"xpstar.dll "
exec sp_addextendedproc xp_regdeletevalue,"xpstar.dll "
exec sp_addextendedproc xp_regenumvalues,"xpstar.dll "
exec sp_addextendedproc xp_regread,"xpstar.dll "
exec sp_addextendedproc xp_regremovemultistring,"xpstar.dll "
exec sp_addextendedproc xp_regwrite,"xpstar.dll "
go 

发布了55 篇原创文章 · 获赞 1 · 访问量 28万+
展开阅读全文

没有更多推荐了,返回首页

©️2019 CSDN 皮肤主题: 大白 设计师: CSDN官方博客

分享到微信朋友圈

×

扫一扫,手机浏览