<div>
With Windows 2000 you are limited to a maximum of 1000. &nbsp;You will have to get additional values using a range.
</div>


With Windows 2000 you are limited to a maximum of 1000.  You will have to get additional values using a range.

<div>
OK. There is no way around that limit? With Windows 2003 is it different?<br />
Ylva
</div>


OK. There is no way around that limit? With Windows 2003 is it different?
Ylva

<div>
<div class="content wysiwyg-content">
Hello!<br />
I am using a linked server to query Active directory and<br />
SELECT * FROM OpenQuery(ADSI,'&lt;LDAP://sk<wbr />olhem1/DC=<wbr />skola,DC=s<wbr />undsvall,d<wbr />c=local&gt;;(<wbr />&amp;(objectCa<wbr />tegory=Per<wbr />son)(objec<wbr />tClass=use<wbr />r));name, adspath;subtree') where name='be89mape'<br />
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.<br />
I hope you understand the question...<br />
Ylva
</div>
</div>


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

Just 1000 answers when trying to query Active Directory

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.