From the course: Microsoft SQL Server 2016: Installation and Administration

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Configure linked servers

Configure linked servers - SQL Server Tutorial

From the course: Microsoft SQL Server 2016: Installation and Administration

Start my 1-month free trial

Configure linked servers

“

- [Instructor] In this video, we're going to take a look at linked servers in SQL Server 2016. Now typically, linked servers are configured to enable your database engine to execute Transact-SQL statements against another instance of SQL Server or perhaps another database such as an Oracle database. And many types of OLE DB data sources can be configured as linked servers, including Microsoft Access and even Microsoft Excel. Linked servers offer the advantages of the ability to access data from outside of SQL Server, the ability to issue distributed queries, updates, and commands, as well as transactions on heterogeneous data sources, and also the ability to address diverse data sources similarly. In other words, your developers can simply write Transact-SQL statements that they're familiar with while they're accessing data that sits on other systems. So what we're going to do is demonstrate how to set up a linked server, and in the first instance of SQL Server that we have is our…

Contents