Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-05-16 : 09:42:34
|
| Maya writes "I couldn't find a satisfactory answer anywhere online yet (that didn't involve having to use software) so here goes:I'm working on a Win2k machine and SQL Server 2000 (I think). I've been asked to run a query that compares email addresses in two different databases that reside on two different servers based off a contract number. I've found how to query different tables on the same server, but nothing about two different servers, and I'd like to just use plain old SQL, as I'm working with the SQL Query manager and printing my results out to a text file. Could someone please tell me how to do it or point me to a good, comprehensible source? Thanks in advance and sorry if this is a bad question, but I'm still pretty new to the whole DB thing. :)" |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2003-05-16 : 10:37:17
|
| Have a read on linked servers in Books Online.Jay White{0} |
 |
|
|
|
|
|
How to query two databases (tables) that reside on two different servers?