Just 1000 answers when trying to query Active Directory

Hello!
I am using a linked server to query Active directory and
SELECT * FROM OpenQuery(ADSI,'<LDAP://skolhem1/DC=skola,DC=sundsvall,dc=local>;(&(objectCategory=Person)(objectClass=user));name, adspath;subtree') where name='be89mape'
does work when I ask for one of the first 1000 users but not if I ask for any of the others. What I want to do is to compare the OU that is stored in the SQL-server with the OU the user actually belongs to in AD so that is why I don't want to give the ou in the LDAP-string.
I hope you understand the question...
Ylva
YlvahoAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Anthony PerkinsConnect With a Mentor Commented:
With Windows 2003 it is supporsedly 1500 (I have never tested it). See here for more info:

Searching Using Range Retrieval
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ldap/ldap/searching_using_range_retrieval.asp
0
 
Anthony PerkinsCommented:
With Windows 2000 you are limited to a maximum of 1000.  You will have to get additional values using a range.
0
 
YlvahoAuthor Commented:
OK. There is no way around that limit? With Windows 2003 is it different?
Ylva
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.