Number of rows returned from a AD query

[Guest_imported]

Hi
I'm writting a SP on SQL7 that it contected to
my company Active Directory.

The problem is that i get only the first 1000 records
from the AD (i should get about 5000 records)

I have added the " SET ROWCOUNT 0" line in the T-SQL query
but i didn't help.
I get the same 1000 rows if i try to get the data from a VB program.

If you have a soulotion Please help !!!
Thx x10 !!

 

[Tim1]

Hiya,

There does not appear to be any reason why you should only get 1,000 rows returned, especially if you have use the SET ROWCOUNT 0 command.

It would be worth checking with your DBA if they have set any config items to limit the rowcount to 1000, maybe to reduce the hit of large querys on the server.

Tim

 

[Guest_imported]

I'm getting the same problem. Did anyone resolve this issue diffinitively??? Thank you.

 

[tlbroadbent]

I read the following in the microsoft.public.active.directory.interfaces Newsgroup.

"Active Directory will return a max of 1000 objects per query. You can use Paged Controls with LDAP queries, not certain what you can do with SQL Server. Alternatively, you can make a registry change for this limit on a server by server basis."

Unfortunately, he doesn't explain how to make the registry change and I can't help. Another entry in the newsgroup confirms the info about the 1000 record limit. The author of that note provided a link to his Active Directory page. It has several other links. Perhaps, you'll find something to help.

http://www.coppersoftware.com/software/activedirectory/

Terry Broadbent

"The greatest obstacle to discovery is not ignorance -- it is the illusion of knowledge." - Daniel J Boorstin

 

[Guest_imported]

Thanks Terry, I'll check it out.