What is Linked Server in SQL Server

Home >> Dababase Interview Questions >> Sql Server Interview Questions

Posted on May 26th , 2010 by Admin

Linked Servers is SQL Server concept by we can add more SQL Server to a Group and query both the SQL Server dbs usig TSQL Statements. With the help of linked server we can create very fresh,clean, easy to follow, SQL statements that allow remote data to be retrieved, joined and combined with local data. These two Stored Procedure sp_addlinkedserver, sp_addlinkedsrvlogin will be used add new Linked Server.