What Is Linked Server?

What Is Linked Server?

In this post i will let you know What Is Linked Server?.A linked server is simply a connection to an Object Linking and Embedding Database (OLEDB) data source.Technically, OLEDB is a Microsoft standard API for retrieving data from a wide variety of data.Linked server to enable the SQL Server Database Engine to execute commands against OLE DB data sources outside of SQL Server.After you create a linked server, SQL Server can log into another database server.That means you can run queries on a remote server.

Linked servers offer the following advantages:

1. The ability to access data from outside of SQL Server.
2. The ability to issue distributed queries, updates, commands, and transactions on heterogeneous data sources across the enterprise.
3. The ability to address diverse data sources similarly.