---
title: "What is a Linked Server?"  
description: "What is a Linked Server?"  
author: "Anonymous User"  
published: 2011-05-11  
updated: 2020-09-20  
canonical: https://www.mindstick.com/interview/877/what-is-a-linked-server  
category: "mssql server"  
tags: ["mssql server"]  
reading_time: 1 minute  

---

# What is a Linked Server?

Linked Servers is a concept in SQL Server by which we can add other SQL Server to a Group and query both the SQL Server dbs using T-SQL Statements. With a linked server, you can create very clean, easy to follow, SQL statements that allow remote data to be retrieved, joined and combined with local data. Stored Procedure sp_addlinkedserver, sp_addlinkedsrvlogin will be used add new Linked Server.

## Answers

### Answer by Anonymous User

Linked Servers is a concept in SQL Server by which we can add other SQL Server to a Group and query both the SQL Server dbs using T-SQL Statements. With a linked server, you can create very clean, easy to follow, SQL statements that allow remote data to be retrieved, joined and combined with local data. Stored Procedure sp_addlinkedserver, sp_addlinkedsrvlogin will be used add new Linked Server.


---

Original Source: https://www.mindstick.com/interview/877/what-is-a-linked-server

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.