Custom SSMS Reports in SP2 - Enterprise Manager Taskpad View
This is probably one of the most requested reports for Management Studio, a simple overview of the total size and used space for your database files like that available in Enterprise Manager for SQL 2000 via the Taskpad view. Whilst Management Studio does have a Disk Usage report at the database level, this is not without its issues (most of which are fixed in SP2 BTW where this report has been broken down into a number of smaller reports to avoid the overhead it used to have in prior releases) and most importantly doesn't really give you a clear overview IMHO like Taskpad used to in Enterprise Manager. Attached to this post is the EM Taskpad.rdl custom report which replicates the Taskpad view for Enterprise Manager. Install instructions are the same as in the previous post except that this report is aimed at the database object type on Object Explorer. Enjoy! You can see a screenshot of the report here
Update: I've updated the report definition in the post attachment. Thanks to Steve Kass for pointing out a slight issue with the query used to display the database properties. If a database was owned by a windows user which had server access via a group the join between sys.databases.owner_sid and sys.server_principals.sid would not produce any rows so the top section of the report would be blank. This has been changed to use suser_sname(owner_sid) which should work regardless.