Re: Copy Active directory Users to a SQL DB table - Daily

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

On Jun 21, 2:00 am, Yas <yas...@xxxxxxxxx> wrote:
On 20 Jun, 23:39, "itsmillertim...@xxxxxxxxx"

<itsmillertim...@xxxxxxxxx> wrote:
It is, but really is it necessary. You can connect to AD directly
from SQL as it were a remote SQL server, and to me this makes more
sense.

Yes to me too :-) however I'm limited by the 1000 limit of AD and
there are over 2000 users that I need to retrive.

Yas

You're limited to 1000, if you don't specify a page size in your
query. If you the page size, it will return the query results in
pages of whatever size you select. It will pause slightly between
each page (but you won't notice it in the script), and will continue
until no more records that match the query are returned. Yep, you can
even set it to 1000, but not more. Try it; it will work.

.

Relevant Pages

  • Re: Copy Active directory Users to a SQL DB table - Daily
    ... from SQL as it were a remote SQL server, and to me this makes more ... if you don't specify a page size in your ... it will return the query results in ... In the example script I posted to your question in the ...
    (microsoft.public.scripting.vbscript)
  • Refresh ODBC/DNS Linked tables In Access 2000
    ... certain on the exact mechanism by which this is ... but whenever you query or open a linked ... There should be no need for additional VBA ... >to remote SQL Server 2000 server. ...
    (microsoft.public.access.externaldata)
  • Run query with IP address
    ... I want to run a query that connects to a remote SQL server via an IP ... what am I missing? ... Tim ...
    (microsoft.public.sqlserver.programming)
  • 3 questions..
    ... via a script that is customizable by the person running ... where to start the query. ... How do I specify for example to ... named Texas with neted OU's Houston and Dallas can I make ...
    (microsoft.public.windows.server.scripting)
  • Re: Need script to list various groups and there users
    ... Glad you got the script working. ... query you specify the distinguished Name of the OU as the base of the query ... MVP Directory Services ... This explains how to specify the attribute values to retrieve in the ...
    (microsoft.public.windows.server.active_directory)