SQL 2000删除和恢复危险存储过程的语句

2007年11月30日 - 未有留言 - 学习笔记 - 浏览:2,706 | 大小:小中大 | 繁體 | English | 本文短网址为：http://bit.ly/bwb3SD

首先，这篇是我从网路上拷贝来的。具体的出处也找不到了。所以，在这里只好对不起作者了。没署上您的名字
------------------------------------------
删除的语句：

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'