title: SQL get table row count for specific table in DB
body: <p>How Can i iterate thru the all my DB's and get a row count for each employee table?
  Each client is has there own DB, need to find the total employees in each DB.</p>
  
  <p>Been trying to figure out how to use <strong>sp_MSforeachdb</strong> </p>
  
  <pre><code>sp_MSforeachdb 
  @command1 = 'select count(*) from employee'
  </code></pre>
  
  <p>Can output in seperate tables or would be good in one table wiht the DB name.</p>