title: Microsoft SQL Server capped 100,000 select
body: <p>Using a python wrapper to query a Microsoft SQL Server database.</p>
  
  <p>The python package name is pyodbc, it uses DB API 2.0.</p>
  
  <p>I create a cursor and <code>fetchall()</code> entries from a table that should contain about 120k rows.</p>
  
  <p>It retrieves only 100k rows.</p>
  
  <p>I tried to count(*) from the table, it returns only 100k.<br>
  I tried to select * from table except top X, it only returns 100k - X entries</p>
  
  <p>I would expect <code>fetchall()</code> to return all entries uncapped since there are <code>fetchmany()</code> and <code>fetchval()</code> functions</p>
  
  <p>What could be the issue?</p>
  
  <hr>
  
  <p>edit: fixed.</p>
  
  <p>the db copy was capped for some reason. thx @Mark Rotteveel</p>