title: calculate size of sql azure database
body: <p>How can I calculate the current size of a SQL Azure Database? (Not the maximum size limit)</p>
  
  <p>Several places (<a href="http://blogs.msdn.com/b/sqlazure/archive/2010/08/10/10048453.aspx">like this</a>) suggest using this sql: </p>
  
  <pre><code>SELECT SUM(reserved_page_count) * 8192
  FROM    sys.dm_db_partition_stats
  </code></pre>
  
  <p>However when executing this as the Administrator login I get this error: </p>
  
  <pre><code>Msg 297, Level 16, State 1, Line 1
  The user does not have permission to perform this action.
  </code></pre>