Some time ago, I needed to sync down a list of AD users to use as a lookup (as opposed to querying LDAP on demand). I found this little gem: How to avoid 1000 rows limitation when querying active directory (AD) from SQL 2005 with using custom code. It works great, especially since I submitted a bug fix.

In any case, the process is very simple:

1. Download and open the MSADHelper2.rar project files
2. Point Visual Studio at the target server and deploy
3. Run the installation script provided in the post – Pay attention though, there’s some configuration, installation, and test statements in there

I highly recommend you download and tuck this project away on disk somewhere, even if you don’t need it yet. It’s worked flawlessly for me and been a huge help.