title: Developer: how to get reporting data from about 20 databases?
body: <p>I'm a junior developer in our team. In one project we have about twenty databases in one SQL Server instance. We have db_owner rights to these databases. </p>
  
  <p>My intention is to monitor certain things from these databases (e.g. file size). But because we don't have sysadmin rights, we don't have all those management tools for these databases. Now, my solution is to write "reporting scripts" using stored procedures. These sp's use sp_foreachdb extensively. My question is that is this a good approach for this problem? What other methods/solutions there is available? </p>