Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Support Infrastructure Q4: What is the difference between remote servers and linked servers?

April 26, 2017difference INFRASTRUCTURE linked Q4 remote servers support

0

Posted

Support Infrastructure Q4: What is the difference between remote servers and linked servers?

1 Answer

0

Posted

The biggest difference is that a remote server only allows you to execute a stored procedure that exists on another SQL Server, whereas a linked server allows you to run distributed queries and transactions, between any of your linked servers. Because remote servers are only provided for backward compatibility and linked servers provide more functionality than remote servers, you should always use linked servers.