Linked Server And Remote Servers

Linked Server And Remote Servers

Post by A.M » Sat, 23 Aug 2003 17:39:23



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

 
 
 

Linked Server And Remote Servers

Post by Dinesh.T. » Sat, 23 Aug 2003 17:49:58


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