中国稳网用户

手工还原SQL时提示xp_dirtree出错的处理办法

来源:   作者:   日期:2018-12-21
分享到:
您可以在 
在SQL2000的企业管理器中运行: 



use master 
exec sp_addextendedproc xp_subdirs,'xpstar.dll'  
exec sp_addextendedproc xp_dirtree,'xpstar.dll'  
exec sp_addextendedproc xp_regread,'xpstar.dll' 
exec sp_addextendedproc 'xp_cmdshell','xplog70.dll' 
exec sp_addextendedproc xp_enumgroups,'xplog70.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_regremovemultistring,'xpstar.dll'  
exec sp_addextendedproc xp_regwrite,'xpstar.dll'  
exec sp_addextendedproc xp_fixeddrives,'xpstar.dll'  
go 



然后还原数据库,


推荐 】 【 打印

中国稳网 版权所有 wendns.com