title: Easy way to find out how many rows in total are stored within SQL Server Database?
body: <p>I'm looking for easy way to count all rows within one SQL Server 2005/2008 database (skipping the system tables of course)? I know i could use</p>
  
  <pre><code>SELECT COUNT (COLUMN) FROM TABLE
  </code></pre>
  
  <p>and do it for each  table and then add it up but would prefer some automated way?</p>
  
  <p>Is there one?</p>