Use this script to list Active Direct users from SQL Server 2005. 'ADSI', 'droplogins'
sp_dropserver
GO
EXEC master.dbo.sp_addlinkedserver @server = N'ADSI', @srvproduct=N'ADSDSOObject', @provider=N'ADsDSOObject', @datasrc=N'adsdatasource'
EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'ADSI',@useself=N'False',@locallogin=NULL, @rmtuser=N'Domain\DomainUser',@rmtpassword='Password'
SELECT
* FROM OPENQUERY
(
ADSI
sn,
sAMAccountName,
displayName,
mail,
telephoneNumber,
mobile,
physicalDeliveryOfficeName,
department,
division
FROM ''LDAP://servername.domainname.org or .com''
WHERE objectCategory = ''Person'' AND objectClass = ''user'' '
,'SELECT givenName,)