Active Directory-How do I display more than 1000 records?

[FancyPrairie]

I have created a linked server for Active Directory and have created the following query. But I only receive 1000 records. From what I understand, I should be able to set the Page Size property. But that doesn't seem to work. I have also tried setting the Size Limit property, but no luck there either.

What am I doing wrong?

SELECT     *
FROM         OPENROWSET('AdsDsoObject', 'User ID=;Password=;ADSI Flag=0x11;Size Limit=0;Page Size=20000', 
                      'SELECT
        sAMAccountName,
        givenname,
        middleName,
        sn,
        displayName
    FROM
        ''LDAP://OU=xxx,OU=xxx,DC=xx,DC=xxx,DC=xx''
    WHERE
        objectCategory = ''Person''
        AND objectClass = ''user''
    ')
                       Rowset_1

 

[tsuji]

Instead of setting it to 20000, try set it to smaller within limit, 1000 (which is the adsi query limited page size) or slightly below. After all, it is the purpose of the setting to page through it, not forcing it to expand beyond the limit. But, I know not linked server.