Another easy way to handle this is create a stored procedure for the query on the remote server. Then execute it from the local server using the 4-part procedure name. All filtering and such will take place on the remote server and you'll only get back the results.

Todd Fifield