title: DB file size from master..sysaltfiles
body: <p>I'm trying to retrieve db sizes of all databases in my SQL Server 2005 instance. I found this </p>
  
  <pre><code>select filename, size, 8192.0E * size / 1048576.0E as result
  from master..sysaltfiles
  </code></pre>
  
  <p>Is the result varibale in KB? How can get this to MB? I'm confused.</p>