Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Access from 2 different SQL servers

Status
Not open for further replies.
tapks

tapks

IS-IT--Management
Sep 6, 2001
72
0
0
IN
Hi!

I have got two different tables in two different SQL Servers in the network. I want to access both the tables at the same time through a single select statement. How can I do it.

Pl help me out.

Tapks
 
Sort by date Sort by votes
Just add one of the SQL Servers in the linked servers area of the one who is going to execute the Statement. Beware that this method is kinda slow when there is a slow network between them, but otherwise, it rules!!
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

gbaughma
  • Locked
  • Question
SQL Performance
Replies
11
Views
162
pjw001
pjw001
bharons
  • Question
Pick up value from combobox
Replies
0
Views
141
bharons
bharons
V
  • Question
xp_cmdshell vs psexec - this SQL server forgets credential to an W10 share
Replies
0
Views
200
Volvere
V
elly00
  • Locked
  • Question
create sql view using batch file
Replies
5
Views
117
Mike Lewis
Mike Lewis
grnzbra
  • Locked
  • Question
T-SQL Dialog Box
Replies
8
Views
102
Chris Miller
Chris Miller

Part and Inventory Search

Sponsor

Back
Top