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 |
|
srireddyp
Starting Member
8 Posts |
 Posted - 2006-05-30 : 16:38:21
|
| Hi Friends,I have two sqlservers,One is on 20.144 and other one is on 20.41I need to access some data from 20.41 to 20.144And do some changes to it and update 20.144 with modified data.How can I achive this in SQL Server ?I have some idea with oracle like create a dblinkto access data between two diff servers.Do we have any thing here ?Thanks for help.Srini |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-05-30 : 16:40:13
|
| You can use linked servers. Check them out in SQL Server Books Online for more details. Once the linked server has been setup, you refer to the remote object using its four part naming convention:SELECT ...FROM ...INNER JOIN LinkedServerName.DatabaseName.ObjectOwner.ObjectNameON ...Tara Kizeraka tduggan |
 |
|
|
|
|
|
DBLinks in SQL Server ?