What is a linked server?
@chinmay-7Wyeml
•
Oct 26, 2024
Oct 26, 2024
1.4K
A linked server configuration enables SQL Server to execute commands against OLE DB data sources on remote servers. With a linked server, you can create very clean, easy–to-follow SQL statements that allow remote data to be retrieved,joined , and combined with local data. The ability to issue distributed queries and perform commands with transactions on heterogeneous sources is one of the benefits of using l inked servers.