Querying Multiple SQL Servers in one statement

From: Devin (anonymous_at_discussions.microsoft.com)
Date: 07/29/04

  • Next message: Vishal Parkar: "Re: Querying Multiple SQL Servers in one statement" 
    Date: Thu, 29 Jul 2004 11:19:20 -0700

    I currently have information stored on two different SQL
    servers. I need to run a query that qeurys both at the
    same time making comparisions. I would like to be able to
    do this in on select statement. Both machines are on a
    local network.

    First I need to know if this can be done, and if it can,
    if someone could point me in the right direction or
    provide an example that would be great.

    Thanks
    Devin

  • Next message: Vishal Parkar: "Re: Querying Multiple SQL Servers in one statement"

    Relevant Pages

    • Re: How to combine existing collections to include or exclude...
      ... "Matthew Hudson" wrote: ... Servers you want minus the ones you don't want ... [edit query statement/Criteria] ... Add computers you don't want to show up in Collection B ...
      (microsoft.public.sms.admin)
    • RE: How to combine existing collections to include or exclude...
      ... "Matthew Hudson" wrote: ... Servers you want minus the ones you don't want ... Add computers you don't want to show up in Collection B ... will see if I can't just send you the collection queries and the query ...
      (microsoft.public.sms.admin)
    • Re: router causing strange DNS behaviour?
      ... These cobbled together ISP networks can ... Initial query took about 4.5 secs ... Rogers is a Canadian ISP, and their name servers should have ...
      (comp.os.linux.networking)
    • Re: Boolean query algorithms
      ... Does that mean the query is broken up into 2 processes that are ... also my question relates to how said queries be them sql ... Google use 'chunck servers'. ... any of the 10 chunck servers that hold each chunk of data. ...
      (alt.internet.search-engines)
    • Re: 550 5.7.1 NDR caused by Exchange using A record instead of MX
      ... Thanks for the RFC reference David. ... If that initial mx query ... Mail servers are so touchy anymore because of SPAM that servers ... > Exchange is required to query the A record if no MX records exist. ...
      (microsoft.public.exchange.connectivity)