Posted on

SQL

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.

Leave a Reply