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 |
|
Jay99
468 Posts |
 Posted - 2002-03-14 : 08:59:57
|
| Whats the diff?Jay |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2002-03-14 : 09:05:04
|
| Linked server can be accessed in queries via svr.db.owner.tbl and can usually be incorporated in distributed transactions.For remote servers can only call stored procedures.Linked servers only available v7+Note that a distributed query is often not a good idea and is in execution very different from a local query.==========================================Cursors are useful if you don't know sql.Beer is not cold and it isn't fizzy. |
 |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-03-14 : 09:07:57
|
It's hard to tell, I think in the case of linked servers, your local server is establishing a relationship to the linked server. A remote server is just a server that's not local. I've been reading through some of the Books Online entries and this is what I'm getting.In SQL 6.5 remote servers had a slightly different meaning, and were close to, but not quite, a linked server. I think that remote servers allow you to execute remote procedure calls, without needing a linked relationship that allows you access to it's data (for instance, a remote call to a backup procedure). Linked servers can do everything a remote server can do, and more.Brit snipers on the loose! Run! Run! Run for you lives!  Edited by - robvolk on 03/14/2002 09:08:43 |
|
|
|
|
|
|
Linked vs. Remote Servers