One of the things about ADSI is that you can use it to query the Global Catalog, which is import to us as we have several thousand users spread across multiple forests.
Also, you let the SQL Server determine which domain controller to use. That way, if a domain controller is down when the query runs, it can automatically be redirected to one that is working. Just make sure you have more than one Global Catalog Server. > -----Original Message----- > From: Zaphod Beeblebrox [mailto:[EMAIL PROTECTED] > Sent: Wednesday, February 22, 2006 11:00 AM > To: CF-Community > Subject: Re: LDAP: Group List > > Here's what I've uncovered for using ADSI queries. This is a view > that I've created to pull all current active directory users who are > 'normal' and not 'disabled'. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:5:197764 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/5 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:5 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54