½«Óа²È«ÎÊÌâµÄSQL¹ý³Ìɾ³ý.±È½ÏÈ«Ãæ.Ò»ÇÐΪÁË°²È«!
ɾ³ýÁ˵÷ÓÃshell£¬×¢²á±í£¬COM×é¼þµÄÆÆ»µÈ¨ÏÞ
MS SQL SERVER2000
ʹÓÃϵͳÕÊ»§µÇ½²éѯ·ÖÎöÆ÷
ÔËÐÐÒÔϽű¾:
use master
exec sp_dropextendedproc 'xp_cmdshell'
exec sp_dropextendedproc 'xp_enumgroups'
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_regremovemultistring'
exec sp_dropextendedproc 'xp_regwrite'
drop procedure sp_makewebtask
go
ɾ³ýËùÓÐΣÏÕµÄÀ©Õ¹:
exec sp_dropextendedproc 'xp_cmdshell' [ɾ³ý´ËÏîÀ©Õ¹ºó,½«ÎÞ·¨Ô¶³ÌÁ¬½ÓÊý¾Ý¿â]
ÒÔÏÂ3¸ö´æ´¢¹ý³Ì»áÔÚSQL SERVER»Ö¸´±¸·Ýʱ±»Ê¹ÓÃ,·Ç±ØÒªÇëÎðɾ³ý
#exec sp_dropextendedproc 'xp_dirtree' [ɾ³ý´ËÏîÀ©Õ¹ºó,½«ÎÞ·¨Ð½¨»ò¸½¼ÓÊý¾Ý¿â]
#exec sp_dropextendedproc 'Xp_regread' [ɾ³ý´ËÏîÀ©Õ¹ºó, »¹ÔÊý¾Ý¿â¸¨Öú]
#exec sp_dropextendedproc 'xp_fixeddrives' [ɾ³ý´ËÏîÀ©Õ¹ºó,½«ÎÞ·¨»¹ÔÊý¾Ý¿â]
»Ö¸´½Å±¾
use master
EXEC sp_addextendedproc xp_cmdshell ,@dllname ='xplog70.dll'
EXEC sp_addextendedproc xp_enumgroups ,@dllname ='xplog70.dll'
EXEC sp_addextendedproc xp_loginconfig ,@dllname ='xplog70.dll'
EXEC sp_addextendedproc xp_enumerrorlogs ,@dllname ='xpstar.dll'
EXEC sp_addextendedproc xp_getfiledetails ,@dllname ='xpstar.dll'
EXEC sp_addextendedproc Sp_OACreate ,@dllname ='odsole70.dll'
EXEC sp_addextendedproc Sp_OADestroy ,@dllname ='odsole70.dll'
EXEC sp_addextendedproc Sp_OAGetErrorInfo ,@dllname ='odsole70.dll'
EXEC sp_addextendedproc Sp_OAGetProperty ,@dllname ='odsole70.dll'
EXEC sp_addextendedproc Sp_OAMethod ,@dllname ='odsole70.dll'
EXEC sp_addextendedproc Sp_OASetProperty ,@dllname ='odsole70.dll'
EXEC sp_addextendedproc Sp_OAStop ,@dllname ='odsole70.dll'
EXEC sp_addextendedproc xp_regaddmultistring ,@dllname ='xpstar.dll'
EXEC sp_addextendedproc xp_regdeletekey ,@dllname ='xpstar.dll'
EXEC sp_addextendedproc xp_regdeletevalue ,@dllname ='xpstar.dll'
EXEC sp_addextendedproc xp_regenumvalues ,@dllname ='xpstar.dll'
EXEC sp_addextendedproc xp_regremovemultistring ,@dllname ='xpstar.dll'
EXEC sp_addextendedproc xp_regwrite ,@dllname ='xpstar.dll'
EXEC sp_addextendedproc xp_dirtree ,@dllname ='xpstar.dll'
EXEC sp_addextendedproc xp_regread ,@dllname ='xpstar.dll'
EXEC sp_addextendedproc xp_fixeddrives ,@dllname ='xpstar.dll'
go
È«²¿¸´ÖƵ½"SQL²éѯ·ÖÎöÆ÷"
µã»÷²Ëµ¥ÉϵÄ--"²éѯ"--"Ö´ÐÐ"£¬¾Í»á½«Óа²È«ÎÊÌâµÄSQL¹ý³Ìɾ³ý¡£
|