Описание тега linked-server
The SQL Server "linked server" feature makes it possible to execute commands, such as a SELECT statement, on a remote server.
Use this tag for any questions related to SQL Server's linked server feature.
A linked server configuration enables SQL Server to execute commands against OLE DB data sources on remote servers. Linked servers offer the following advantages:
- Remote server access.
- The ability to issue distributed queries, updates, commands, and transactions on heterogeneous data sources across the enterprise.
- The ability to address diverse data sources similarly.
An OLE DB provider is required for this functionality to work.
See MSDN for more information.