Linked Server in SQL

Question

What is Linked Server ?

Satyapriya Nayak · Answer

http://msdn.microsoft.com/en-us/library/ms188279.aspx http://www.quackit.com/sql_server/sql_server_2008/tutorial/linked_servers.cfm http://www.sqlservercentral.com/articles/Distributed+Queries/anintroductiontolinkedservers/1366/

Vithal Wadje · Answer

linked server is the concept in sql server by using which you can add (link) another server to your existing server. means your existing server make link with another server such as oracle or any so you can make a operation on database of both sql server on a single sql server opening screen . to see goto Server objec t --- Linked Server -- its displyas the list of linked server -- then right click on existing linked server -and clik on New linked server i hope you have understand it.