Using OPEN QUERY against ADS
-
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" -
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
-
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" -
Push it into a table and refresh periodically.
Andy
Andy
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply