Welcome to dbFreaks.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

How to overcome the AdsDsoObject, ADSI 5000 row limit

 
   Database Help (Home) -> Programming RSS
Next:  I: ODBC error  
Author Message
BlueSky

External


Since: Oct 22, 2008
Posts: 10



(Msg. 1) Posted: Thu Apr 15, 2010 11:45 am
Post subject: How to overcome the AdsDsoObject, ADSI 5000 row limit
Archived from groups: microsoft>public>sqlserver>programming (more info?)

I would like to gather all my 15000+ users via a single query and was running
up against the 5000 row limit. I have 2000, 2005 and 2008 in my environment.
Does the limit magically disappear in any version?

Is there a way to overcome the limit?

Here's my query:

SELECT *
FROM OPENROWSET(
'AdsDsoObject'
,'User ID=xxxx;Password=xxxx;ADSI Flag=0x11;Page Size=10000'
,'SELECT SamAccountName, DistinguishedName, employeeID, displayName,
department, telephoneNumber, mail, givenName,SN
FROM ''LDAP://xxxxxx.xxx.xxx/ DC=xxx, DC=net''
WHERE objectCategory = ''Person'' AND objectClass= ''user''
order by EmployeeID
')
--
thanks for your help!

The Spirit gives life; the flesh counts for nothing! (Jn 6:63)

 >> Stay informed about: How to overcome the AdsDsoObject, ADSI 5000 row limit 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Update Limit - I'm using Access 2003 SP2 with MSDE 2000. I copied a function from an internet site that changes text to proper case. Using an update query with the function works for only the first 10,000 records (out of 42,000+). The last 32,000+ records remain..

limit on # of temp tables? - I have a script that creates several (4+) temp tables. However, when I run the script, it acts like the first two exist but the latter ones do not. I use the code SELECT TABLE_NAME FROM tempdb.INFORMATION_SCHEMA.TABLES WHERE [TABLE_NAME] LIKE '%#%'....

Limit returned recordset size - I am using ODBC to connect to a SQL database from a proprietary application. The result set of a query I am executing is too large for the application to handle. I am wondering if anyone has any ideas of how I can create multiple SELECT statements..

LIMIT x,y versus Sql Server - I use SQL Server and I need to make some pagination on my web site. The TOP syntax has not any offset, for example to return 1 to x records like MySql LIMIT 1, 10 there is no syntax for this. Does anyone know how to get a range of records like the LIMIT...

Log fie size limit??? - Hi, Is there a log file size limit for SQL Server 2005 Std.? I seem to be having issues writing into our SQL Server database running on SQL Server 2005 Std. My log file size is arond 24GB. Any idea why this would be happening? -- Thanks, Sam
   Database Help (Home) -> Programming All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]