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 |
|
txeriff
Starting Member
2 Posts |
 Posted - 2008-01-17 : 06:37:42
|
| Hi, here goes the question:i have 1 sqlserver 2k5 machine (machine A) and sqlserver 2k (machine b)how do i build a query to select data from 2k machine in a query of 2k5?i mean something like select *from login:passw@machineb.dabatase.dbo.customersthanks! |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2008-01-17 : 10:50:03
|
| Set up a linked server. |
 |
|
|
TRACEYSQL
Aged Yak Warrior
594 Posts |
Posted - 2008-01-18 : 17:43:42
|
| I tried to do this set up linked from SQL2005 to SQL 2000 i did not have much luck with the linked server.In the end i just imported table in using Tools Import data |
|
|
|
|
|
|
select data from 2000 machine from a 2005 machine