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

技术文章

客服中心

业务咨询

531199185
61352289
81721488
376585780
872642803
459248018
61352288
380791050

技术支持

714236853

719304487

1208894568

61352289

在线客服

531199185

61352288

983054746

893984210

当前位置：首页 >> 技术文章 >> 文章浏览

添加时间：2012-4-6　添加： admin　

删除
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_fileexistuse master
exec sp_addextendedproc xp_fileexist,'xpstar.dll'删除 SQL 扩展存储过程 xp_fileexistuse 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

分享到：

【顶部】【关闭】

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

新文章: