A linked server allows remote access. Using this, we can issue distributed queries, update, commands, and transactions across different data sources. A linked server has an OLE DB provider and data source. A linked server allows for access to distributed, heterogeneous queries against OLE DB data sources. After a linked server is created, distributed queries can be run against this server, and queries can join tables from more than one data source. If the linked server is defined as an instance of SQL Server, remote stored procedures can be executed.
Linked server is a object or we can say another database connected in our existing sql connection and saved so that we can treat them as an database entity. ie. serverip.user.table its really helpful for sync.
Typically linked servers are configured to enable the Database Engine to execute a Transact-SQL statement that includes tables in another instance of SQL Server, or another database product such as Oracle. Many types OLE DB data sources can be configured as linked servers, including Microsoft Access and Excel.
Linked server is just like another sql instance connected in existing sql server .
We can link remote server on our server, it is work like usual Database, Linked server must establish connection
Linked server is just like another sql instance connected in existing sql server instance as an object.
Linked Servers allows you to connect to other database instances on the same server or on another machine or remote servers.More Details : http://www.c-sharpcorner.com/uploadfile/suthish_nair/linked-servers-in-sql-server-2008/
Linked Server is the ability to access data from outside of SQL Server. Typically linked servers are configured to enable the Database Engine to execute a Transact-SQL statement that includes tables in another instance of SQL Server, or another database product such as Oracle
http://www.dotnetfunda.com/interviews/show/370/what-is-a-linked-server
Linked Servers allows you to connect to other database instances on the same server or on another machine or remote servers.
Linked Server is To connect two different databases. By using Linked server we can easily access the other server tables.
It is mainly used for make the connection of sql server with other database server like oracle,Sql Server
http://www.c-sharpcorner.com/uploadfile/suthish_nair/linked-servers-in-sql-server-2008/
Configure a linked server to enable the SQL Server Database Engine to execute commands against OLE DB data sources outside of the instance of SQL Server
Connect with other servers. It could be SQL or Oracle or any other server.
Connect with other SQL server(s) and Query both the server database.