Xp_adsi Extended Stored Procedure For MS SQL
The xp_adsi extended stored procedure allows you to read data from the Active Directory. It is easy to use and is a quick way to get the Active Directory data. The perfect tool for the MS SQL Server. The extended stored procedure supports WinNT and LDAP ADSI providers.
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:
[, [@filter =] 'filter']
[, [@field_names =] 'name1[,...n]']
[, [@scope =] 'scope']
- The ADsPath string for the WinNT or LDAP provider.
[@filter =] 'filter'
- A search filter string:
LDAP provider - like '(objectClass=user)'
WinNT provider - like 'user'
[@field_names =] 'name1[,...n]'
- The comma-separated list of field names. Use '*' to output all fields.
[@scope =] 'scope'
'GET_CHILD_OBJECTS' - outputs child objects
'GET_GROUP_MEMBERS' - outputs group names (for the user account only)
'GET_OBJECT_LIST' - outputs info about object itself
You may release the DLL from the Server (to delete or replace the file), by using the SQL command: