try:set rowcount 0
SELECT *
FROM OPENQUERY(ADSI,
'SELECT TelephoneNumber,name, mail, title, sAMAccountname
FROM ''LDAP://dc01'' WHERE objectCategory = ''Person'' and objectClass = ''user''
')
SELECT *
FROM OPENQUERY(ADSI,
'SELECT TelephoneNumber,name, mail, title, sAMAccountname
FROM ''LDAP://dc01'' WHERE objectCategory = ''Person'' and objectClass = ''user''
')
1000笔记录是AD Server的限制,vb或c#都可以通过改变page size设置返回的数据数,要想办法可以在sql上设置page size的值。