you can find some info on using QPENQUERY() to query Active Directory at www.sqlmag.com

There are quite a number of threads in the discussion groups.

-Mike

>Hi All,
>
>From SQL2K I need to query Active Directory. I've never worked with AD or LDAP queries. Can anyone point me to the related article??
>
>Any help would be appreciated.
>
>Daniel