What is a linked server?

Technology CommunityCategory: SQLWhat is a linked server?
VietMX Staff asked 3 years ago

Linked server facilitates the ease of linking with heterogeneous servers. Using linked servers, you can manipulate data on the remote servers and even integrate with local data.

Stored procedures: sp_linkedservers gives you the list of linked servers available on the server.