What is a linked server in SQL Server?

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.
Features and concepts of Analysis Services
Features and concepts of Analysis Services - Analysis service provides a combined view of the data used in OLAP or Data mining........
What is Analysis service repository?
What is Analysis service repository? - Each server running analysis service has a repository to store objects of the computer.......
SQL Server - What is SQL service broker?
What is SQL service broker? - SQL service broker provides asynchronous queuing functionality to SQL server.......
Post your comment