Solved

I want to join 2 tables from 2 different servers

Posted on 2007-04-03
3
227 Views
Last Modified: 2010-07-27
I want to join 2 tables from 2 different servers.  I envisioned something like:

SELECT *
FROM Server1.Datebase.table t1 LEFT JOIN Server2.Database.table t2 ON t1.Index = t2.Index

Can this be done in t-sql?
0
Comment
Question by:jamesrbarnes
3 Comments
 
LVL 21

Assisted Solution

by:Kevin3NF
Kevin3NF earned 100 total points
ID: 18843923
You need to set up the "other" server as a linked server.  Check out sp_addlinkedserver in Books Online, or look in the GUI for the version you are using...which is what...2000 or 2005?
0
 
LVL 50

Accepted Solution

by:
Lowfatspread earned 300 total points
ID: 18844013
yes linked server
and 4 part naming

Servername.Datebasename.ownername.tablevieworfunctionName
0
 
LVL 2

Assisted Solution

by:poogy21
poogy21 earned 100 total points
ID: 18849202
yes. setup a "linked server" and you could do exactly that.
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SQL Help 27 57
RLDC Reporting in Visual studio 11 30
How do you pull mopre then 1000 records using VB.NET Directory Services namespace 2 33
AJAX pass along a variable 3 46
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question