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 |
|
kumar_j
Starting Member
7 Posts |
 Posted - 2007-10-11 : 18:15:18
|
| Hi all,I installed sql server 2000 server on my machine and i need to connect to sql server 2005 server which is at other machine,Is it possible to connect 2000 to 2005 server and get the data |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-11 : 22:31:32
|
| Yes with linked server or opendatasource. |
 |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2007-10-12 : 03:41:22
|
| Do you want the data as for searching or do you want to transfer the data?Jack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com/SQL |
|
|
|
kumar_j
Starting Member
7 Posts |
Posted - 2007-10-12 : 09:48:08
|
I want to access the dataquote:
Originally posted by jackv
Do you want the data as for searching or do you want to transfer the data?Jack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com/SQL
|
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2007-10-12 : 11:05:56
|
| OK, then do what rmiao suggested . I thought you might want to just transfer the dataJack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com/SQL |
|
|
|
|
|
|
Connecting 2000 server to 2005 server