As SQL Server describes linked server in BOL (Books Online): 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
