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