Ole db access interface for Microsoft Active Directory

You can use the Microsoft ole db access interface for the Microsoft directory service to access information in the Microsoft Windows 2000 directory service. The maximum number of objects returned for queries using this access interface is 1000.

Http://msdn.microsoft.com/zh-cn/library/ms190803.aspx

Building a Hybrid Active Directory and SQL table datasource View

SQL Server: Using openquery to retrieve Active Directory User Info

Query AD data through SQL Server 2008 R2 Database

Joining Active Directory data with SQL Server Data: cannot fetch a row from OLE DB provider "yourprovider" for linked server "yourlinkedserver"