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 |
|
beachtime1999
Starting Member
25 Posts |
 Posted - 2007-10-04 : 17:02:56
|
| If I had a remote server(app66) with one users mappedand I deleted it and added a linked server(app66) and I could see the master tables. why is it not the same the same? |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-04 : 17:57:03
|
| A remote server configuration allows for a client connected to one instance of SQL Server to execute a stored procedure on another instance of SQL Server without establishing a separate connection, but it doesn't support distributed queries. Both stored procedures and distributed queries are allowed against linked servers. |
 |
|
|
|
|
|
remote VS. Linked servers