删除SQL Server 2000数据库危险扩展

xwencai

删除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

tianlin

没明白，能详细点吗