select openquery

• pzmrcd

  Default port

  Points: 1419

  More actions

  February 18, 2009 at 5:36 am

  #201307

  Hi I have included Active Directory as a linked server to SQLserver 2005.

  when I execute the following select query..

  SELECT * FROM

  OpenQuery(ADSI, 'SELECT givenName, sn FROM ''LDAP://DC=test,DC=com'' WHERE objectCategory=''user'' ')

  where givenname is not null

  it works fine ..but the NUMBER OF RECORDS DISPALYED IN NOT MORE THAN 1000..I expect around 5ooo records..how can we increase this return result set to contain more records.

  Thanks

• Bruce W Cassidy

  SSChampion

  Points: 12668

  More actions

  February 18, 2009 at 11:56 am

  #946188

  [font="Verdana"]Can you give us some sort of idea as to which records are missing that you expect to see in the list?[/font]

• noeld

  SSC Guru

  Points: 96590

  More actions

  February 18, 2009 at 12:16 pm

  #946207

  pzmrcd (2/18/2009)

  ---

  Hi I have included Active Directory as a linked server to SQLserver 2005.

  when I execute the following select query..

  SELECT * FROM

  OpenQuery(ADSI, 'SELECT givenName, sn FROM ''LDAP://DC=test,DC=com'' WHERE objectCategory=''user'' ')

  where givenname is not null

  it works fine ..but the NUMBER OF RECORDS DISPALYED IN NOT MORE THAN 1000..I expect around 5ooo records..how can we increase this return result set to contain more records.

  Thanks

  There is a Built-in Limit in AD to 1000 page-size It can be overridden using registry hacks but I don't remember the Key.

  Google is your friend!

  
  * Noel