create dummy table inset all record of Active directory

Sagarp
Posted by Sagarp under Sql Server category on | Views : 2943
SELECT * INTO Ldaptable from OPENQUERY (ADSI,'SELECT streetAddress,mobile,mail,department,sn,givenName,sAMAccountName from ''LDAP://DC=xxx,DC=com'' WHERE objectClass=''User''')

Thanks
SagarP

Comments or Responses

Login to post response