"Murphy was an optimist!"
SQL October 19, 2004 6:25 pmPosted by djuggler in : Daily Life
Wahoo! I just did an INNER JOIN across two different servers!!
Linking two servers
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.