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...
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..
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"