November 11, 2001 at 10:16 pm
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"
November 11, 2001 at 10:38 pm
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
November 12, 2001 at 3:26 am
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"
November 12, 2001 at 4:41 am
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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy