欢迎访问清竹软件站!    客服热线:400-0247-467   点击这里给我发消息 客服QQ:165461152
查看:4059 | 回复:0
楼主:清竹科技
清竹科技发表于:2014-07-04 11:00:34

鉴于删除并不是最好的解决办法,在这里建议使用SQL2005作为SQL数据库服务器
删除。


使用查询分析器,输入以下代码并执行。

-------------------------------------

删除代码:

use master
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'
exec sp_dropextendedproc 'xp_cmdshell'
exec sp_dropextendedproc 'xp_dirtree'
exec sp_dropextendedproc 'xp_dropwebtask'
exec sp_dropextendedproc 'xp_makewebtask'
exec sp_dropextendedproc 'xp_runwebtask'
exec sp_dropextendedproc 'xp_subdirs'
exec sp_dropextendedproc 'sp_MsgetVersion'
exec sp_dropextendedproc 'xp_enumerrorlogs'
exec sp_dropextendedproc 'xp_fixeddrives'
exec sp_dropextendedproc 'xp_enumdsn'
exec sp_dropextendedproc 'sp_oaCreate'
DROP PROCEDURE sp_addsrvrolemember
DROP PROCEDURE sp_addextendedproc
go


--------------------------------

恢复代码:

create procedure sp_addextendedproc
@functname nvarchar(517),/* (owner.)name of function to call */ @dllname varchar(255)/* name of DLL containing function */ as
set implicit_transactions off
if @@trancount > 0
begin
raiserror(15002,-1,-1,'sp_addextendedproc')
return (1)
end
dbcc addextendedproc( @functname, @dllname)
return (0)
go
use master

exec sp_addextendedproc 'xp_cmdsheel','odsole70.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'
dbcc addextendedproc ("xp_regread","xpstar.dll")
exec sp_addextendedproc 'Xp_regremovemultistring','xpstar.dll'
exec sp_addextendedproc 'Xp_regwrite','xpstar.dll'
exec sp_addextendedproc 'xp_cmdshell','xplog70.dll'
exec sp_addextendedproc 'xp_dirtree','xpstar.dll'
exec sp_addextendedproc 'xp_dropwebtask','xpweb70.dll'
exec sp_addextendedproc 'xp_makewebtask','xpweb70.dll'
exec sp_addextendedproc 'xp_runwebtask','xpweb70.dll'
exec sp_addextendedproc 'xp_subdirs','xpstar.dll'
exec sp_addextendedproc 'sp_MSgetversion','xpstar.dll'
go