加入收藏 | 设为首页 | 会员中心 | 我要投稿 李大同 (https://www.lidatong.com.cn/)- 科技、建站、经验、云计算、5G、大数据,站长网!
当前位置: 首页 > 站长学院 > MsSql教程 > 正文

SQLserver数据库危险存储过程删除与恢复方法

发布时间:2020-12-12 12:35:26 所属栏目:MsSql教程 来源:网络整理
导读:SQL的扩展的删除与恢复 删除 代码如下: use master exec spdropextendedproc xpcmdshell exec spdropextendedproc xpdirtree exec spdropextendedproc xpenumgroups exec spdropextendedproc xpfixeddrives exec spdropextendedproc xploginconfig exec spdro
SQL的扩展的删除与恢复
删除
代码如下:
use master
exec spdropextendedproc “xpcmdshell“
exec spdropextendedproc “xpdirtree“
exec spdropextendedproc “xpenumgroups“
exec spdropextendedproc “xpfixeddrives“
exec spdropextendedproc “xploginconfig“
exec spdropextendedproc “xpenumerrorlogs“
exec spdropextendedproc “xpgetfiledetails“
exec spdropextendedproc “SpOACreate“
exec spdropextendedproc “SpOADestroy“
exec spdropextendedproc “SpOAGetErrorInfo“
exec spdropextendedproc “SpOAGetProperty“
exec spdropextendedproc “SpOAMethod“
exec spdropextendedproc “SpOASetProperty“
exec spdropextendedproc “SpOAStop“
exec spdropextendedproc “Xpregaddmultistring“
exec spdropextendedproc “Xpregdeletekey“
exec spdropextendedproc “Xpregdeletevalue“
exec spdropextendedproc “Xpregenumvalues“
exec spdropextendedproc “Xpregread“
exec spdropextendedproc “Xpregremovemultistring“
exec spdropextendedproc “Xpregwrite“
drop procedure spmakewebtask
go

恢复
代码如下:
use master
exec spaddextendedproc xpcmdshell,“xpcmdshell.dll“
exec spaddextendedproc xpdirtree,“xpstar.dll“
exec spaddextendedproc xpenumgroups,“xplog70.dll“
exec spaddextendedproc xpfixeddrives,“xpstar.dll“
exec spaddextendedproc xploginconfig,“xplog70.dll“
exec spaddextendedproc xpenumerrorlogs,“xpstar.dll“
exec spaddextendedproc xpgetfiledetails,“xpstar.dll“
exec spaddextendedproc spOACreate,“odsole70.dll“
exec spaddextendedproc spOADestroy,“odsole70.dll“
exec spaddextendedproc spOAGetErrorInfo,“odsole70.dll“
exec spaddextendedproc spOAGetProperty,“odsole70.dll“
exec spaddextendedproc spOAMethod,“odsole70.dll“
exec spaddextendedproc spOASetProperty,“odsole70.dll“
exec spaddextendedproc spOAStop,“odsole70.dll“
exec spaddextendedproc xpregaddmultistring,“xpstar.dll“
exec spaddextendedproc xpregdeletekey,“xpstar.dll“
exec spaddextendedproc xpregdeletevalue,“xpstar.dll“
exec spaddextendedproc xpregenumvalues,“xpstar.dll“
exec spaddextendedproc xpregread,“xpstar.dll“
exec spaddextendedproc xpregremovemultistring,“xpstar.dll“
exec spaddextendedproc xpregwrite,“xpstar.dll“

(编辑:李大同)

【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容!

    推荐文章
      热点阅读