Hi,
In Enterprise manager under security we have Linked Servers and Remote
Servers.
What is the differece between Linked Servers and Remote Servers?
Thanks,
Ali
In Enterprise manager under security we have Linked Servers and Remote
Servers.
What is the differece between Linked Servers and Remote Servers?
Thanks,
Ali
Remote Servers are provided only for backward compatibility.In the
BooksOnLine topic 'Establishing Security for Remote Servers' , its
mentioned:
" Support for remote servers is provided for backward compatibility only.
New applications that must execute stored procedures against remote
instances of SQL Server should use linked servers instead."
--
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com
Quote:> Hi,
> In Enterprise manager under security we have Linked Servers and Remote
> Servers.
> What is the differece between Linked Servers and Remote Servers?
> Thanks,
> Ali
1. Linked Server and Remote Server
Hello All,
I wanted to know the difference between linked server
and remote server (in Enterprise manager). When would you
add a server to linked server and when would you add
server to a remote server.
Thanks
Anand
2. mapi spooler aint working after changing Administrator passwd
3. Linked Server vs Remote Server
4. Moving from DAO 3.5 to DAO 3.6
5. Remote Server -- Changing from Remote Server to Linked Server
6. pgsql/src/include/nodes (readfuncs.h)
7. Access the data on Remote Server or Link Server
8. Help! Updating a portion of information in a table
9. Configuring Linked Server to Remote Index Server
10. Linked server vs. remote server
11. Remote server to Linked server
12. SQL 6.5 Remote Server to SQL 7 Linked Server
13. Linked Servers/Selecting from remote server