Xp adsi description
The xp_adsi extended stored procedure allows you to read data from Active Directory

The xp_adsi extended stored procedure allows you to read data from Active Directory. It is easy to use and the quick way to get Active Directory data.

The perfect tool for MS SQL Server. The extended stored procedure supports WinNT and LDAP ADSI providers.

How to install:

Copy the xp_adsi.dll over to your SQL Server
Binn directory.

Add your new Extended Stored Procedure from a Visual Studio Data Project,
or using the SQL Server Enterprise Manager, or by executing the following
SQL command:
sp_addextendedproc 'xp_adsi', 'xp_adsi.dll'