删除MSSQL危险存储过程的代码

2008-03-16 12:05

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

恢复SQL 扩展存储过程 xp_fileexist

恢复SQL 扩展存储过程 xp_fileexist use master exec sp_addextendedproc xp_fileexist,'xpstar.dll' 删除 SQL 扩展存储过程 xp_fileexist use master exec sp_addextendedproc 'xp_fileexist' drop procedure sp_makewebtask go 已经测试过   OK

查询DLL文件与对应存储过程关联
select text,object_name(id) as spname from syscomments where object_name(id) like 'sp_o%' or object_name(id) like 'xp_r%' or object_name(id) like 'xp_c%'

xpstar.dll xp_readerrorlog
xplog70.dll xp_cmdshell
sqlmap70.dll xp_readmail
xprepl.dll xp_repl_encrypt
xprepl.dll xp_repl_convert_encrypt
xprepl.dll xp_repl_help_connect
xprepl.dll xp_replproberemsrv
xpqueue.dll xp_createprivatequeue
xpqueue.dll xp_resetqueue
xpqueue.dll xp_controlqueueservice
xpqueue.dll xp_readpkfromqueue
xpqueue.dll xp_readpkfromvarbin
odsole70.dll sp_OACreate
odsole70.dll sp_OADestroy
odsole70.dll sp_OAGetErrorInfo
odsole70.dll sp_OAGetProperty
odsole70.dll sp_OAMethod
odsole70.dll sp_OASetProperty
odsole70.dll sp_OAStop
xpweb70.dll xp_runwebtask
xpweb70.dll xp_cleanupwebtask
xpweb70.dll xp_convertwebtask
xpweb70.dll xp_readwebtask
xpstar.dll xp_regread
xpstar.dll xp_regwrite
xpstar.dll xp_regdeletevalue
xpstar.dll xp_regaddmultistring
xpstar.dll xp_regremovemultistring
xpstar.dll xp_regenumkeys
xpstar.dll xp_regenumvalues
xpstar.dll xp_regdeletekey

以下是存储过程sp_makewebtask
    --==================================================================================== -- Add extended stored procedures for Web Server support. -- -- sp_makewebtask: Creates and defines the Web Page Task    CREATE PROCEDURE sp_makewebtask @outputf sp_makewebtask
4)          END       SET @retval = 0    -- Create the Web task     EXECUTE @retval = master..xp_makewebtask @outputfile, @query, @username, @procname, @dbname,       @fixedfont, @bold, @italic, @colheaders, @lastupdated, @HTMLheader,       @templatefile, sp_makewebtask