Linked Server

Question

Hi...... How can we define Linked server in ADO.NET. define its properties?

Satyapriya Nayak · Answer

Hi Rajesh 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. Refer http://www.dotnetfunda.com/interview/exam370-what-is-a-linked-server.aspx Thanks