Linked Server in SQL Server

Question

I want to know what is a linked server in SQL server. Thank you.

Jignesh Trivedi · Answer

Hi The Linked Servers option allows us to connect to another instance of SQL Server running on a different machine perhaps remotely may be in a different places. This can be useful if we need to perform distributed queries (query a remote database). Setting up a linked server is quite straight forward in SSMS all you need is details of the remote server and the database that you need to query. please refer http://msdn.microsoft.com/en-us/library/ms188279.aspx http://blog.sqlauthority.com/2007/10/06/sql-server-executing-remote-stored-procedure-calling-stored-procedure-on-linked-server/ http://www.c-sharpcorner.com/uploadfile/suthish_nair/linked-servers-in-sql-server-2008/ hope this will help you.