Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2003
    Location
    Alexandria, VA
    Posts
    1

    Unanswered: Get Data from another Server

    I need to connect to a database on another server, I have permission to do that. What do I need to do to be able to accomplish it. I am using ASP as the scripting language.

    Gary Martin

  2. #2
    Join Date
    Jul 2002
    Location
    Village, MD
    Posts
    621
    What about linked server?

  3. #3
    Join Date
    Apr 2003
    Location
    Evansville, Indiana
    Posts
    76
    Yep...you may want to do a sp_addlinkedserver on one of the servers pointing to the other server, then you use a fully qualified name for the table. Example:

    SELECT lt.Field1, lt.Field2...
    FROM LinkedServerName.DbName.DBOwner.TableName AS lt

    You can join tables in the local database to this fully qualified table name just as if it existed in that database.

    Kael

Posting Permissions

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