What is Distributed Queries in SQL Server?

 Posted by Poster on 6/17/2009 | Category: Sql Server Interview questions | Views: 7073

Distributed queries access data from multiple heterogeneous data sources. These data sources can be stored on either the same or different computers. Microsoft SQL Server supports distributed queries by using OLE DB.

SQL Server users can use distributed queries to access the following:

#. Distributed data stored in multiple instances of SQL Server.
#. Heterogeneous data stored in various relational and nonrelational data sources accessed by using an OLE DB provider.

For more details visit http://msdn.microsoft.com/en-us/library/ms188721.aspx


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response