SQL Server Performance

How to maintaining Active Directory details in database

Discussion in 'SQL Server 2008 General Developer Questions' started by ramasubbup, May 6, 2009.

  1. ramasubbup New Member

    Team,
    I need to keep all the AD details (groups,users,..etc) in my database.
    One way is to create a linked server to ADS service and get the info
    Is there any other way or new feature in SQL Server 2008?
    Thanks & Regards
    Prabhu S
  2. techbabu303 New Member

  3. moh_hassan20 New Member

    Also you can use SSIS with OLE DB Provider.
    To retrieve all the users from ActiveDirectory, use the query:
    "SELECT cn FROM 'LDAP://DC=DOMAINCONTROLLER,DC=local'WHERE objectClass='User'"

Share This Page