All 7 Linked Servers questions
More in Linked Servers
How do you write a query that retrieves data from a table on a linked server? What are the security considerations when configuring authentication for a linked server connection? What performance issues commonly arise when querying data through a linked server, and how can you address them? How do you test and verify that a linked server connection is working correctly after it has been configured? How would you troubleshoot a linked server query that is running much slower than expected? What are alternatives to linked servers for integrating data from multiple different database systems, and when might they be a better choice?
Advertisement
Back to results for “Set”
SQL Server › Linked Servers

What is a linked server in SQL Server, and why would you set one up?

Beginner

Answer

A linked server lets your SQL Server instance connect to and query data from another database server, whether it is another SQL Server instance or a different type of database entirely, allowing you to write queries that combine data from multiple separate database servers as if they were part of the same system.
EXEC sp_addlinkedserver
  @server = 'RemoteServer',
  @srvproduct = '',
  @provider = 'SQLNCLI',
  @datasrc = 'RemoteServerAddress';
Real-world example A company with separate databases for sales and inventory sets up a linked server so their reporting team can write a single query combining data from both systems without manually exporting and merging data by hand.

Common follow-ups: What types of databases can a linked server connect to besides SQL Server?;Does setting up a linked server require special permissions?

Query Optimization & Plans;SQL Server Security & Permissions
All 7 Linked Servers questions