What is linked server?

 Posted by Rajni.Shekhar on 4/5/2012 | Category: Sql Server Interview questions | Views: 1511 | Points: 40

One sql server is added to another sql server, this concept is called linked server. Linked server is used to extract query from different sql server.

select tab1.* from dbserver1.db1.dbo.table1 tab1, 

dbserver1.db2.dbo.table2 tab2
where tab1.id=tab2.id

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Posted by: Akiii on: 4/10/2012 | Points: 10
Interesting point Rajani....

Thanks and Regards

Login to post response