August 10, 2014

what is linked server in sql server?

Linked server means to retrieve the data from the other server to connect our own instance, before configure the linked server we must know the target server login and password then only we access the data from the other server.

Linked server means access the data from one server another server is called linked server. store procedure is sp_addlinkedserver.

When we have to run the distributed transactions we need to linkup the servers internally we use linked servers concept.Here distributed transactions means A query which has to executed on multiple servers at a time is called distributed transactions.

No comments:

Post a Comment