Query looking at rows on 2 different servers? RRS feed

  • Question

  • HI I Have to do a query that will produce an unmatched listing.

    On server A which is our vendor's server, which is a SQL Server 2005, we have a transactions table. We want to see for the past 2 days only:
    which InvoiceNumber(int 20 null) is NOT on our Document server
    which is mysql the column there is:
    Docnumber Varchar 64 Binary.
    I am not sure how to get to the servers. I am used to getting to a different server in c# using 'connection strings' but how to do this in query?

    Thursday, July 28, 2011 12:27 AM

All replies