• 0

[SQL Server 2000] Acessing data across servers


Question

Is it possible to get data from 2 servers in the same sql statement? For example

select [server1].[dbo].[table1].*,[server2].[dbo].[table1].* 
from ......etc.

Esentially, I want to draw data from 2 tables on 2 different servers in the same statement. Does anyone know if this is possible or the correct syntax for this?

Link to comment
Share on other sites

3 answers to this question

Recommended Posts

  • 0
What is the correct syntax?  I tried what I have above and it didn't work.

584817048[/snapback]

I don't think it's possible without linking servers. You could try this.

SELECT   *
FROM      OPENDATASOURCE(
         'SQLOLEDB',
         'Data Source=ServerName;User ID=MyUID;Password=MyPass'
         ).Northwind.dbo.Categories

Link to comment
Share on other sites

This topic is now closed to further replies.
  • Recently Browsing   0 members

    • No registered users viewing this page.