Active Directory 1000 rows limitation

we are using

select distinguishedname, employeeid, sn, middlename, givenname, displayname, samaccountname, mail, cn, telephonenumber
from OpenQuery( ADSI, 'SELECT telephonenumber, distinguishedname, employeeid, sn, middlename, givenname, displayname, samaccountname, mail, cn, telephonenumber
FROM ''LDAP://DC=domain,DC=xxx,DC=xxx''
WHERE objectCategory = ''Person'' AND objectClass= ''user''

But it only returns 1000 rows which i read all around that is the default.

How do you set this to be higher.

Thanks

Try adding the connection attribute "Page Size" to your connection string and specify higher value. By default, the ADSI search API restricts the first result set size to 1000 rows and the rest of the rows have to be paged one by one. There are probably other connection string attributes that needs to be specified for the search result to be expanded. I do not know the exact details so you will have to check the ADSI OLEDB provider documentation.