What is a linked server?
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.
0