Posted on Leave a comment

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.