How can I copy data like firstname, lastname, email from Active Directory into a SQL Server table?
Any help will be appreciated
Technology Tips and News
How can I copy data like firstname, lastname, email from Active Directory into a SQL Server table?
Any help will be appreciated
You can use LDAP query
refer http://www.mssqltips.com/sqlservertip/2580/querying-active-directory-data-from-sql-server/
http://www.skylinetechnologies.com/Blog/Article/1309/Querying-Active-Directory-through-SQL-Server-Using-OpenRowset-and-OpenQuery.aspx