Check out openquery() to access data on linked servers. It will return only the results of the query after processing the query on the remote server.