您好,欢迎访问一九零五行业门户网

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

您可以在 在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
您可以在
在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
其它类似信息

推荐信息