Troubleshooting for xp_dirtree errors when manually restoring SQL statements

Run usemasterexecsp_addextendedprocxp_subdirs, xpstar. Taobao, xpstar. Taobao, xpstar. dllexecsp_addextendedprocxp_cmdshell, and xplog70.dllexec in SQL2000 Enterprise Manager.

You can run: use master exec using xp_subdirs, xpstar. dll exec using xp_dirtree, xpstar. dll exec using xp_regread, xpstar. dll exec sp_addextendedproc xp_using exec, xplog70.dll

You can
Run:



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', 'xp log70. dll'
Exec sp_addextendedproc xp_enumgroups, 'xp log70. dll'
-- Exec sp_addextendedproc xp_loginconfig, 'loglog70. 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