Results 1 to 9 of 9
  1. #1
    Join Date
    Dec 2004
    Location
    Ogden, UT
    Posts
    1

    Unanswered: one SQL Statement to access databases on different servers

    I know the SQL syntax to join two tables in different databases on the ame server, but does anyone know if a SQL statement will allow you to join tables from different databases on different servers?

  2. #2
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  3. #3
    Join Date
    Dec 2004
    Posts
    46
    After u have done above, just select xxx from [server].db.dbo.tablename

  4. #4
    Join Date
    Feb 2004
    Location
    San Antonio, TX
    Posts
    565
    Quote Originally Posted by rdjabarov
    did you forget one? hmmmmm?

    OpenRowset() and you dont need a linked server for this AD HOC method.

  5. #5
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Trust me, rdjabarov is very familiar with OpenRowset().
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  6. #6
    Join Date
    Feb 2004
    Location
    San Antonio, TX
    Posts
    565
    and its a wild right that just doesnt connect...

    boy i tell ya bob. the challenger better land some cause he's swinging wild and not hitting anything

  7. #7
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Huh? I'm missing your metaphors.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  8. #8
    Join Date
    Feb 2004
    Location
    San Antonio, TX
    Posts
    565
    non-sequitor
    just illustrating the pugilistic nature of certain member's relationships

  9. #9
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    I guess everyone has to have a purpose in life...
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •