>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.
--
Christof