>>Yes. I tried it and works fine.
>
>Have you tested this on the actual data or test data? Linked Server do have some performance implications, because SQL first needs to run a query against the free table copying the entire result set into a temporary table. In the second step SQL server uses this temporary table instead of the free table to execute the actual query.

It was on test data. For my case however the free tables are in general small, max 500 records.