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 |
|
kappa02
Yak Posting Veteran
65 Posts |
 Posted - 2004-03-25 : 10:28:11
|
| If I wanted to query against two SQL Server databases that are on a different machine would I have to used sp_linkedservers And is that my only option? |
|
|
samsekar
Constraint Violating Yak Guru
437 Posts |
Posted - 2004-03-25 : 10:33:43
|
| Ofcourse.. Check BOL for furthur details. use fully qualified name in the Query for selecting the records.- Sekar |
 |
|
|
raymondpeacock
Constraint Violating Yak Guru
367 Posts |
Posted - 2004-03-25 : 10:34:02
|
| No, you have another option to linked servers. Look up OPENROWSET in BOLRaymond |
|
|
|
samsekar
Constraint Violating Yak Guru
437 Posts |
Posted - 2004-03-25 : 10:39:02
|
| Oh.. Thanks Raymond.. How did i forgot that.- Sekar |
|
|
|
raymondpeacock
Constraint Violating Yak Guru
367 Posts |
Posted - 2004-03-25 : 10:41:07
|
| Sorry Sekar, we were submitting replies at the same time. The "No" wasn't meant for you, so don't think I was being rude :)And we all forget things ...Raymond |
|
|
|
samsekar
Constraint Violating Yak Guru
437 Posts |
Posted - 2004-03-25 : 10:47:14
|
quote:
Originally posted by raymondpeacock
Sorry Sekar, we were submitting replies at the same time. The "No" wasn't meant for you, so don't think I was being rude :)And we all forget things ...Raymond
No worries, I strongly belive we are here to learn new things every day.- Sekar |
|
|
|
|
|
|
linkedserver ??