You will need to add a "Linked Server" on the server the queries are running on.

This will allow you to execute queries as normal (with the addition of the server in the object qualifier) ie:

insert into local_table

select * from remote_server.dbo.remote_database.table

Check out Books On Line for sp_addlinkedserver

Matt