Using OPEN QUERY against ADS

  • ckempste

    SSCoach

    Points: 17983

    Hi

    I have created a linked server to AD, when I run a query against a CN it stops at 1000 rows? (running via query analyser). Is this a bug? or am I doing some very wrong...

    SELECT name

    FROM OPENQUERY( ADSI, ' SELECT name

    FROM ''LDAP://163.232.xx.xx/CN=Application Users,DC=ppl2kdv''')

    I cant see any properties in the linked server, open query or query analyser that would be causing this..

    Cheers

    Chris


    Chris Kempster
    www.chriskempster.com
    Author of "SQL Server Backup, Recovery & Troubleshooting"
    Author of "SQL Server 2k for the Oracle DBA"

  • Andy Warren

    SSC Guru

    Points: 119694

    I believe its a built in limitation of the provider. It's not a speed demon as it is, you don't want to return a couple hundred thousand rows. I'll try to find where it's documented.

    Andy

  • ckempste

    SSCoach

    Points: 17983

    1000 rows is not only a limitation but a bug as far as im concerned 🙂

    any ideas on another way to expose AD via views to app users?


    Chris Kempster
    www.chriskempster.com
    Author of "SQL Server Backup, Recovery & Troubleshooting"
    Author of "SQL Server 2k for the Oracle DBA"

  • Andy Warren

    SSC Guru

    Points: 119694

    Push it into a table and refresh periodically.

    Andy

    Andy

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply