AtvSoftware
Home
Products
About Us
Contact Us
« Return To Products //



Xp_adsi Extended Stored Procedure For MS SQL
Description How to Install How to Use How to Uninstall

Version: 2.0
Requirements: MS SQL Server
File Size: 57 KB
Download License: FREE

// Description

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.

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'

exec master.dbo.xp_adsi {[@adspath =]'adspath'}
    [, [@filter =] 'filter']
    [, [@field_names =] 'name1[,...n]']
    [, [@scope =] 'scope']

Parameters:
[@adspath =]'adspath'
- 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'
- Where:
    '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 drop the extended stored procedure by using the SQL command:

sp_dropextendedproc 'xp_adsi'

You may release the DLL from the Server (to delete or replace the file), by using the SQL command:

DBCC xp_adsi (FREE)

// Top Products   WinCrypto
  Xp_Pop3
  Xp_smtp
  Xp_adsi
  DB Event Alerter [MS SQL]
  DB Event Alerter [Postgre SQL]
  DB Event Alerter [Firebird]
  DB Event Alerter [MySQL]
  DB Event Alerter [Oracle]
  VFP Post_event Library

Go Back Go Up Go Forward Copyright © AtvSoftware 2023