Results 1 to 3 of 3

Thread: How to select table data from different SQL Servers?

  1. #1
    Join Date
    Dec 2002
    Location
    Taiwan, R.O.C.
    Posts
    2

    Question How to select table data from different SQL Servers?

    I have to access data between two SQL Servers(version 6.5), how to perform it?

  2. #2
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    In SQL 6.5 you can't directly access a table in another server while connecting to one.

    But you can execute a stored procedure in another server and fetch data. To do this you need to setup remote logins in the remote server (see sp_addremotelogin in BOL).

    If you want to join tables from two servers in a query then only option is to connect to a SQL 7.0/2K server which has linked server configured to both SQL 6.5 servers.

  3. #3
    Join Date
    Dec 2002
    Location
    Taiwan, R.O.C.
    Posts
    2

    Question

    Does it mean I can fetch table data on another server by executing a stored procedure on another server while connecting to one server? If yes, how to perform it?

Posting Permissions

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