thinkinterview » interview questions » ADO.NET
« Previous

ADO.NET Interview Questions

next »
question

What is a Linked Server?

Answer Description:

A linked server configuration enables SQL Server to execute commands against OLE DB data sources on remote servers.  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.

Linked servers offer the following advantages:
 
  1.     Remote server access.
  2.     The ability to issue distributed queries, updates, commands, and transactions on heterogeneous data sources across the enterprise.
  3.     The ability to address diverse data sources similarly.

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.

 


Next Queston » You create a Web application to process XML documents. The Web ap...
You create a Web application to process XML documents. The Web application receives XML document files from several sources, reads them, and store... View full queston »