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

日期: 2008-04-01 作者:xiaoqiao 来源:TechTarget中国

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

我们一直都在努力坚持原创.......请不要一声不吭,就悄悄拿走。

我原创,你原创,我们的内容世界才会更加精彩!

【所有原创内容版权均属TechTarget,欢迎大家转发分享。但未经授权,严禁任何媒体(平面媒体、网络媒体、自媒体等)以及微信公众号复制、转载、摘编或以其他方式进行使用。】

微信公众号

TechTarget微信公众号二维码

TechTarget

官方微博

TechTarget中国官方微博二维码

TechTarget中国

电子邮件地址不会被公开。 必填项已用*标注

敬请读者发表评论,本站保留删除与本文无关和不雅评论的权力。

作者

xiaoqiao
xiaoqiao

相关推荐