Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Active Directory Import Question

Author  Topic 

brandonl
Yak Posting Veteran

58 Posts

Posted - 2005-03-31 : 13:37:59
I'm sure this has been asked, and i have searched, but I'm probably not using the right search terms

Our AD domain has the 1000 row limit on a general query. I have set up the AD domains as linked servers and would like to import the records into a SQL table. Is there a way, via a query, to go by pages of 1000 and import the data?

I've seen that it can be done using scripting and others, but I am looking for a way to do it in just a SQL query.

Thanks!

~BrandonL
   

- Advertisement -