title: Select all tables with at least one row of data inserted
body: <p>I want return all tables that have at least one row of data.</p>
  
  <p>I was using this:</p>
  
  <pre><code>SELECT DISTINCT(OBJECT_NAME(OBJECT_ID)) 
  FROM SYS.DM_DB_PARTITION_STATS ST
  WHERE ST.ROW_COUNT &gt; 0 AND OBJECT_ID &gt; 100
  </code></pre>
  
  <p>But I don't want use the table <code>SYS.DM_DB_PARTITION_STATS</code>.  </p>
  
  <p>I want to know another way to find these tables?</p>
  
  <p>Any clues?</p>
  
  <p>thanks.</p>