What is Linked Server in SQL Server [Resolved]

Posted by Amatya under C# on 2/16/2016 | Points: 10 | Views : 249 | Status : [Member] | Replies : 2
What is Linked Server in SQL Server. Its Uses and benefits?

Feel free to share informations 9731764134
Thanks



Responses

Posted by: Rajnilari2015 on: 2/16/2016 [Member] [Microsoft_MVP] [MVP] Platinum | Points: 50

Up
0
Down

Resolved
@Amatya Sir,

Linked Servers allows to connect other database instances on the same server or on another machine or remote servers.It allows SQL Server to execute SQL scripts against OLE DB data sources on remote servers using OLE DB providers.The remote servers can be SQL Server, Oracle,PostgreSQL etc. which means databases that support OLE DB can be used for linking servers.

Uses and benefits
In many instances, the data represents 2 different logical sets of data; hence, you have 2 databases. The reason for using linked servers over putting both DBs on the same SQL instance would be to spread the workload out over 2 physical servers for scalability and performance.
In another word, it brings the Distributed Queries in place.

Hope this helps

--
Thanks & Regards,
RNA Team

Amatya, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Amatya on: 2/17/2016 [Member] Bronze | Points: 25

Up
0
Down
Thanks Buddy.. I got something .. but now some doubts are their...

1) I have one DataBase in server1 and another DataBase in server2, then i can do manipulation using Linked Server?

2) If i have a one DataBase in Server1 and in that DataBase i have a table i.e. tblcustomer and in Server2 i have a DataBase and in that i have a table tblCustomerAddress, so can i perform queries using the tables of tblcustomer and tblCustomerAddress?

Thanks in Advance... Since a week iam reading ur forum comments , and the way you have explained is FANTASTIC.. Keep it up @Rajnilari2015

Feel free to share informations 9731764134
Thanks

Amatya, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response