What is a linked server in SQL Server?It enables SQL server to address diverse data sources like OLE DB similarly. It allows Remote server access and has the ability to issue distributed queries, updates, commands and transactions.What is a linked server in SQL Server? Define a linked server.
A linked server allows remote access. Using this, we can issue distributed queries, update, commands, and transactions across different data sources.
A linked server has an OLE DB provider and data source.
|