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 |
|
binublr
Starting Member
1 Post |
 Posted - 2005-12-18 : 08:58:57
|
| I have to administer 3 data bases which are in 3 different networks. How can I link all the 3 databases in one Enterprise manager. I want to execute queries like inseert into network1ip.db1.table1 select * from network2ip.db2.tab1.TIABinu |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2005-12-18 : 09:50:21
|
| use Linked Server. Either use Enterprise Manager to create a linked server or use sp_addlinkedserver.Refer to Books OnLine for details-----------------[KH]Learn something new everyday |
 |
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2005-12-18 : 10:35:54
|
| would this helpso many questions are being asked of this latelyhttp://sqlteam.com/forums/topic.asp?TOPIC_ID=59208 |
|
|
|
|
|
|
linking sql servers across network