<div>
i see the max size ......how do i add the cmd.properties to the script above as im doing this all in sql select.<br />
thanks...............
</div>


i see the max size ......how do i add the cmd.properties to the script above as im doing this all in sql select.
thanks...............

<div>
<div class="content wysiwyg-content">
when i return records from active directory the max no of records i get is 1000<br />
select distinguishedname, employeeid, sn, middlename, givenname, displayname, samaccountname, mail, cn, telephonenumber<br />
&nbsp;from OpenQuery( ADSI, 'SELECT telephonenumber, distinguishedname, employeeid, sn, middlename, givenname, displayname, samaccountname, mail, cn, telephonenumber<br />
&nbsp;FROM ''LDAP://DC=domain,DC=mydc<wbr />,DC=com''<br />
&nbsp;WHERE objectCategory = ''Person'' AND objectClass= ''user''<br />
&nbsp;AND sn &gt;=''m''')<br />
<br />
anyone know why is there a limitiation.....?<br />

</div>
</div>


when i return records from active directory the max no of records i get is 1000
select distinguishedname, employeeid, sn, middlename, givenname, displayname, samaccountname, mail, cn, telephonenumber
 from OpenQuery( ADSI, 'SELECT telephonenumber, distinguishedname, employeeid, sn, middlename, givenname, displayname, samaccountname, mail, cn, telephonenumber
 FROM ''LDAP://DC=domain,DC=mydc,DC=com''
 WHERE objectCategory = ''Person'' AND objectClass= ''user''
 AND sn >=''m''')

anyone know why is there a limitiation.....?


returning records from active directory

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.