Ce site est optimisé pour être consulté depuis un navigateur moderne dans lequel JavaScript est activé.

Selecting data from two different servers in SQL Server

ayi

<t>Selecting data from two different servers in SQL Server</t>

ayi

<t>What you are looking for are Linked Servers. You can get to them in SSMS from the following location in the tree of the Object Explorer: 
 
Server Objects-->Linked Servers 
 
or you can use sp_addlinkedserver. 
 
You only have to set up one. Once you have that, you can call a table on the other server like so:

select<br/>
    *<br/>
from<br/>
    LocalTable,<br/>
    [OtherServerName].[OtherDB].[dbo].[OtherTable]<br/>
<br/>
```<br/>
<br/>
Note that the owner isn't always `dbo`, so make sure to replace it with whatever schema you use.</t>