1.

Explain Linked Server In Sql?

Answer»

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.

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.


Discussion

No Comment Found

Related InterviewSolutions