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

概述SQL的扩展的删除与恢复 删除 代码如下: use master exec spdropextendedproc “xpcmdshell“ exec spdropextendedproc “xpdirtree“ exec spdropextendedproc “xpenumgroups“ exec spdropextendedproc “xpfixeddrives“ exec spdropextendedpro… 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“ 总结

以上是内存溢出为你收集整理的SQLserver数据库危险存储过程删除与恢复方法全部内容，希望文章能够帮你解决SQLserver数据库危险存储过程删除与恢复方法所遇到的程序开发问题。

如果觉得内存溢出网站内容还不错，欢迎将内存溢出网站推荐给程序员好友。