Home > DeveloperSection > Interviews > What is a Linked Server?

Posted on    May-11-2011 5:09 AM

 MSSQL Server MSSQL Server 
 1 Answer(s)
  1144  View(s)
Rate this:

Awadhendra Tiwari

Total Post:510

Posted on    May-11-2011 12:00 AM

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.

Don't want to miss updates? Please click the below button!

Follow MindStick