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
Excerpt from link below states, Active Directory can be accessed from SQLSERVER 2005 by using: Linked Server OpenRowSet Managed Stored Procedure Link : http://www.codeproject.com/KB/database/SQL_Server_%96_Active_Direc.aspx -Sat
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'"