When you say all database, do you include master in that? If master is gone then I dont think you can do much about it. If its just data then I would only expect the other database to be marked as suspect or something similar.

If you look in sysdatabase and sysaltfiles in Master it has the location to the other database files you MAY be able to change it through there. I have never tried this and normally wouldnt recommend this kind of thing but it may help you achieve what you want.

Regards

Jon

>I have a machine with SQL Server 2000 where the data files were put on an external HD. That HD is now gone. The service is still pointing there, and I can't seem to change that through any designer.
>
>Is there a way that I can change where those are pointing? I don't care about the data on that other HD... I just want to be able to use the installation again.
>
>I guess I can always uninstall and reinstall, but I figure it would be good for me to learn how to do this.
>
>Thanks for any help,
>Mike