If you are using SQL Server 7.0 you can create a link server wich will allow what you want. (look in in Entreprise Manager under Security you will find Linked Server)

After that link will be added you will have to add the name of that link in your query.

select * from mylink.mydatabase.dbo.mytable.