How to query Active Directory to fetch more than 1000 rows using Sql Server–Part I

Recently there was a requirement from one of my customers to query Active Directory and load the data into a table in sql server. To be honest I am not developer so I started researching on the topics over the net and took help of some of the internal resources which I had access to….