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 wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Quering data on two servers

Status
Not open for further replies.
mnasuto

mnasuto

Technical User
Oct 22, 2001
87
GB
Hi,

Is it possile to create query where tables are from different databases on different servers?
If yes what is syntacs for selecting one field from each table?

Please help if you can

Best Regards,
M
 
Sort by date Sort by votes
Select <cols>
From ServerName.DataBaseName.OwnerName.<table name>
 
Upvote 0 Downvote
Hi,

Thank you for prompt replay.
I am getting message:

The number name 'Server2.data2.dbo.data2' contains more than the maximum number of prefixes. The maximum is 3.

What I am doing wrong?
Please advice

M
 
Upvote 0 Downvote
HI,

I am getting message invalid object
 
Upvote 0 Downvote
are you getting confused with database name and table name??

because i see both the names are same...

-DNG
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

coorsman
  • Locked
  • Question
Column Data Type. 2
Replies
9
Views
909
Chris Miller
Chris Miller
SashaBuilder3
  • Locked
  • Question
select a single row based on conditions in multiple rows 1
Replies
3
Views
876
SashaBuilder3
SashaBuilder3
peac3
  • Locked
  • Question
fill the gap of hierarchy data
Replies
11
Views
1K
Chris Miller
Chris Miller
Steve Yu
  • Locked
  • Question
How secure is MS SQL on the Internet vs behind firewall inside a LAN 1
Replies
3
Views
567
Chris Miller
Chris Miller
briangriffin
  • Locked
  • Question
Calculating differences every two rows
Replies
2
Views
528
kjv1611
kjv1611

Part and Inventory Search

Sponsor

Back
Top