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

ZDNet软件频道 时间:2009-12-03 作者: | 赛迪网 我要评论()
本文关键词:Server 服务器 SQL
exec sp_dropextendedproc xp_dirtree 

  示例如下:

  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 "

Server

服务器

SQL


百度大联盟认证黄金会员Copyright© 1997- CNET Networks 版权所有。 ZDNet 是CNET Networks公司注册服务商标。
中华人民共和国电信与信息服务业务经营许可证编号:京ICP证010391号 京ICP备09041801号-159
京公网安备:1101082134