刪除 SQLServer 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