SQL的扩展的删除与恢复

SQL的扩展的删除与恢复 </h1> <div id="property"> 2009-10-26 10:06:33  xueheike&#46;net  来源：<a href="http://blog&#46;cnmoker&#46;org/" target="_blank">Robert</a></div><!--引用地址--> 删除use master exec sp_dropextendedproc &#039;xp_cmdshell&#039; exec sp_dropextendedproc &#039;xp_dirtree&#039; exec sp_dropextendedproc &#039;xp_enumgroups&#039; exec sp_dropextendedproc &#039;xp_fixeddrives&#039; exec sp_drop &#46;&#46;&#46; 删除<BR>use master <BR>exec sp_dropextendedproc 'xp_cmdshell' <BR>exec sp_dropextendedproc 'xp_dirtree' <BR>exec sp_dropextendedproc 'xp_enumgroups' <BR>exec sp_dropextendedproc 'xp_fixeddrives' <BR>exec sp_dropextendedproc 'xp_loginconfig' <BR>exec sp_dropextendedproc 'xp_enumerrorlogs' <BR>exec sp_dropextendedproc 'xp_getfiledetails' <BR>exec sp_dropextendedproc 'Sp_OACreate' <BR>exec sp_dropextendedproc 'Sp_OADestroy' <BR>exec sp_dropextendedproc 'Sp_OAGetErrorInfo' <BR>exec sp_dropextendedproc 'Sp_OAGetProperty' <BR>exec sp_dropextendedproc 'Sp_OAMethod' <BR>exec sp_dropextendedproc 'Sp_OASetProperty' <BR>exec sp_dropextendedproc 'Sp_OAStop' <BR>exec sp_dropextendedproc 'Xp_regaddmultistring' <BR>exec sp_dropextendedproc 'Xp_regdeletekey' <BR>exec sp_dropextendedproc 'Xp_regdeletevalue' <BR>exec sp_dropextendedproc 'Xp_regenumvalues' <BR>exec sp_dropextendedproc 'Xp_regread' <BR>exec sp_dropextendedproc 'Xp_regremovemultistring' <BR>exec sp_dropextendedproc 'Xp_regwrite' <BR>drop procedure sp_makewebtask <BR>go<BR><BR><BR>恢复<BR>use master <BR>exec sp_addextendedproc xp_cmdshell,'xp_cmdshell&#46;dll' <BR>exec sp_addextendedproc xp_dirtree,'xpstar&#46;dll' <BR>exec sp_addextendedproc xp_enumgroups,'xplog70&#46;dll' <BR>exec sp_addextendedproc xp_fixeddrives,'xpstar&#46;dll' <BR>exec sp_addextendedproc xp_loginconfig,'xplog70&#46;dll' <BR>exec sp_addextendedproc xp_enumerrorlogs,'xpstar&#46;dll' <BR>exec sp_addextendedproc xp_getfiledetails,'xpstar&#46;dll' <BR>exec sp_addextendedproc sp_OACreate,'odsole70&#46;dll' <BR>exec sp_addextendedproc sp_OADestroy,'odsole70&#46;dll' <BR>exec sp_addextendedproc sp_OAGetErrorInfo,'odsole70&#46;dll' <BR>exec sp_addextendedproc sp_OAGetProperty,'odsole70&#46;dll' <BR>exec sp_addextendedproc sp_OAMethod,'odsole70&#46;dll' <BR>exec sp_addextendedproc sp_OASetProperty,'odsole70&#46;dll' <BR>exec sp_addextendedproc sp_OAStop,'odsole70&#46;dll' <BR>exec sp_addextendedproc xp_regaddmultistring,'xpstar&#46;dll' <BR>exec sp_addextendedproc xp_regdeletekey,'xpstar&#46;dll' <BR>exec sp_addextendedproc xp_regdeletevalue,'xpstar&#46;dll' <BR>exec sp_addextendedproc xp_regenumvalues,'xpstar&#46;dll' <BR>exec sp_addextendedproc xp_regread,'xpstar&#46;dll' <BR>exec sp_addextendedproc xp_regremovemultistring,'xpstar&#46;dll' <BR>exec sp_addextendedproc xp_regwrite,'xpstar&#46;dll' </div>