exec sp_dropextendedproc ‘xp_cmdshell’
如果要恢复它
exec sp_addextendedproc xp_cmdshell ,@dllname =’xplog70.dll’
而为何我要恢复xp_dirtree用上面这个语句就不行了？？
拿起exescope我分析了一下xplog70.dll这个文件，哈哈，看到不少好东西
打开x:/program files/microsoft sql server/mssql/binn目录
看到了我们常用的存储过程了吧
那我们再看看xpstar.dll这个吧
哈哈哈，有不少东西，文件大，到底是不一样
odsole70.dll
sp_oacreate
sp_oadestroy
sp_oageterrorinfo
sp_oagetproperty
sp_oamethod
sp_oasetproperty
sp_oastop
sqlmap70.dll
xp_deletemail
xp_findnextmsg
xp_get_mapi_default_profile
xp_get_mapi_profiles
xp_issqlmailstarted
xp_readmail
xp_sendmail
xp_startmail
xp_stopmail
xp_test_mapi_profile
xpqueue.dll
xp_controlqueueservice
xp_createprivatequeue
xp_decodequeuecmd
xp_deleteprivatequeue
xp_displayqueuemesgs
xp_peekqueue
xp_readpkfromqueue
xp_readpkfromvarbin
xp_resetqueue
xprepl.dll
xp_orbitmap
xp_displayparamstmt
xp_execresultset
xp_intersectbitmaps
xp_makecab
xp_mapdown_bitmap
xp_mergelineages
xp_mergexpusage
xp_oledbinfo
xp_printstatements
xp_proxiedmetadata
xp_repl_convert_encrypt
xp_repl_encrypt
xp_repl_help_connect
xp_replproberemsrv
xp_showcolv
xp_showlineage
xp_unpackcab
xp_varbintohexstr
xpsqlbot.dll
xp_qv
xpstar.dll
sp_getmbcscharlen
sp_ismbcsleadbyte
sp_msgetversion
xp_getadmingroupname
xp_isntadmin
xp_msadenabled
xp_msadsiobjreg
xp_msadsiobjregdb
xp_msadsireg
xp_msfulltext
xp_mslocalsystem
xp_msnt2000
xp_msplatform
xp_setsqlsecurity
xp_adsirequest
xp_availablemedia
xp_dirtree
xp_dsninfo
xp_enum_activescriptengines
xp_enum_oledb_providers
xp_enumdsn
xp_enumerrorlogs
xp_eventlog
xp_fileexist
xp_fixeddrives
xp_freemodule
xp_get_mapi_default_profile
xp_get_mapi_profiles
xp_get_tape_devices
xp_getfiledetails
xp_getnetname
xp_getprotocoldllinfo
xp_instance_regaddmultistring
xp_instance_regdeletekey
xp_instance_regdeletevalue
xp_instance_regenumkeys
xp_instance_regenumvalues
xp_instance_regread
xp_instance_regremovemultistring
xp_instance_regwrite
xp_msx_enlist
xp_ntsec_enumdomains
xp_prop_oledb_provider
xp_readerrorlog
xp_regaddmultistring
xp_regdeletekey
xp_regdeletevalue
xp_regenumkeys
xp_regenumvalues
xp_regread
xp_regremovemultistring
xp_regwrite
xp_servicecontrol
xp_sqlagent_enum_jobs
xp_sqlagent_is_starting
xp_sqlagent_monitor
xp_sqlagent_msx_account
xp_sqlagent_notify
xp_sqlagent_param
xp_sqlagent_proxy_account
xp_sqlmaint
xp_subdirs
xp_terminate_process
xp_test_mapi_profile
xp_unc_to_drive
xp_updateftssqlaccount
xpweb70.dll
xp_cleanupwebtask
xp_convertwebtask
xp_dropwebtask
xp_enumcodepages
xp_makewebtask
xp_readwebtask
xp_runwebtask
都在这里了，当然每个sp的用法我就不多说了