title: MS SQL 2008 - get all table names and their row counts in a DB
body: <p>I'm trying to identify which tables are affected by a data update though an application (developed by others). There are more than 200 tables in the DB and I'd like to avoid checking each of them for changes.</p>
  <h3>Is there any other way where I can list all table names along with their row count?</h3>
  <pre><code>select table_name from information_schema.tables
  </code></pre>
  <p>List out all the tables in my DB buy how do I include number of rows as well?</p>