What is a Linked Server?

Posted by

To view Verified answers click on the button below.

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_addlinkedserverlogin will be used add new Linked Server.