Wahoo! I just did an INNER JOIN across two different servers!!
Pertent links:
Linking two servers
AND
Heterogeneous queries require the ANSI_NULLS and ANSI_WARNINGS options to be set for the connection. This ensures consistent query semantics. Enable these options and then reissue your query.
