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.

Attachment: EM TaskPad.zip
Published Tuesday, November 28, 2006 11:30 PM by sqldbatips
Filed under:

Comments

Wednesday, November 22, 2006 10:24 PM by sqldbatips.com blog

# SSMS Custom Reports Backwards Compatibility (or lack thereof)

Currently with regard to custom reports in SSMS there is no support for SQL 2000 instances (or even databases

Thursday, November 23, 2006 12:49 AM by SimonS SQL Server Stuff

# Taskpad view in SQL2005

Do you want the taskpad view in Management Studio then you need to download Jaspers custom report which

Thursday, November 23, 2006 12:49 AM by SimonS' SQL Server Stuff

# Taskpad view in SQL2005

Do you want the taskpad view in Management Studio then you need to download Jaspers custom report...

Thursday, November 23, 2006 12:52 AM by SimonS SQL Server Stuff

# Role based Permissions view in Managent Studio

Do you want the permission view that is avialble in Enterprise Manager for roles well you need to download

Thursday, November 23, 2006 12:52 AM by SimonS' SQL Server Stuff

# Role based Permissions view in Managent Studio

Do you want the permission view that is avialble in Enterprise Manager for roles well you need...

Thursday, November 23, 2006 9:31 PM by SimonS SQL Server Stuff

# Taskpad view version2

This is a pure plagurism of Jaspers taskpad report . I have reformated the report to look like the taskpad

Thursday, November 23, 2006 9:31 PM by SimonS' SQL Server Stuff

# Taskpad view version2

This is a pure plagurism of Jaspers taskpad report. I have reformated the report to look like the taskpad...

Friday, December 4, 2009 11:46 AM by alzdba

# re: Custom SSMS Reports in SP2 - Enterprise Manager Taskpad View

I wanted to upgrade your marvelous report in BIDS2008. It converts it ok, but when I run it in BIDS2008 it gives me no results. How do I get an overview of SSMS(2008) available parameters and how should I modify the rdl to use them ?

Friday, December 4, 2009 11:46 AM by alzdba

# re: Custom SSMS Reports in SP2 - Enterprise Manager Taskpad View

I wanted to upgrade your marvelous report in BIDS2008. It converts it ok, but when I run it in BIDS2008 it gives me no results. How do I get an overview of SSMS(2008) available parameters and how should I modify the rdl to use them ?