Sizes of ALL Database on an Instance

Revised 8/15/14:

Created a script that combined both syntax for SQL 2000 and 2005+ as well as showing used space and free space:

 

Older post published 2/20/13:

————————————————————————————————————————–

I needed a simple way to show the sizes of each database on a given instance, as well as their total size. This was the solution I came up with:

SQL 2000 Syntax:

Leave a Reply

Your email address will not be published.

HTML tags are not allowed.