FAQ: How do I query Active Directory from SQL Server?

There are several ways but the most commonly used approach of using linked servers hits ona  1000 row limit in the AD OLE DB Provider, here is a solution using SQL CLR, I have not tried it but if it works as advertised then it should help, beware it does use SQLCLR.

Comments

• Anonymous
  March 30, 2007
  PingBack from http://activedirectorytool.com/faq-how-do-i-query-active-directory-from-sql-server/

• Anonymous
  June 04, 2007
  The comment has been removed

• Anonymous
  June 04, 2007
  Yep thats simpler but by default is it not subject to the 1000 row limit I mentioned?

• Anonymous
  May 07, 2008
  So James has responded back to me on ADAM.