I want to know what is a linked server in SQL server.
Thank you.
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Jignesh TrivediPosted Aug 1, 2012, 12:00 AM
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.