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 |
|
wkm1925
Posting Yak Master
207 Posts |
 Posted - 2008-04-21 : 23:42:35
|
| Let say, i've 2 server. Server A having Adb database and Server B having Bdb database.Adb having tblStaff as followID | Department | Name------------------------001 | F41 | JamesBdb having tblDepartment as followDepartment ID | Department Name-----------------------------------F41 | EmgineeringF44 | Human ResourcesIs it possible to create query between them? Con you consult me. Tq. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-21 : 23:47:48
|
| Yes but you have to use Linked Server. |
 |
|
|
wkm1925
Posting Yak Master
207 Posts |
Posted - 2008-04-21 : 23:55:03
|
| If using Linked Server, how about the the performance issue? Can you elaborate it. Tq. |
|
|
|
|
|
|
Cross query between 2 sources