SQL Server Blogs

Voices from the UK SQL Server Community

rdl Taskpad view just like in SQL 2000 Enterprise Manager

Downloads: 1,348 File Size: 49.9kB
Posted By: simonsabin Views: 13,878
Date Added: Thu, Nov 23 2006

Do you miss the task pad view in management studio, well using this custom report you can get the same view.

To use this in SP2 you need to rename the file to .rdl rather that .rdlc

Thanks to Jasper for the original version

Release notes

  • Fixed the database backup times
  • Added extra backups supported by SQL 2005




jjones said:

For SQL 2005 SP2 this report is displaying incorrect information under the Maintenance section. I have a SQL 2005 database that is in simple mode. This report is displaying the results for last full backup under last differential backup row. The results for last differential backup is showing under last full backup row. Also the column alignment when results are returned for any of the 4 last backup rows should be left justified instead of right justified. Under Space Allocated section, the text written inside the gray bar should be left justified. If you have a small amount of used use for tlog, the text is overrunning into the blue bar area.
Thu, Mar 22 2007 3:54 PM

simonsabin said:

Thanks jjones. The latest version fixes your bug.
Fri, Mar 30 2007 2:07 PM

anilpillai said:

I got a "Root Element is Missing" XML error when I tried to run this report. I am running SP2
Mon, May 7 2007 4:39 PM

MoOriginal said:

err can i ask something a bit newbie please - how do you run this or add this in 2005 ? Thanks Mo
Mon, Jun 11 2007 3:43 PM

simonsabin said:

To use this report it. Download it to a location on your machine. Then in SSMS right click on a database, select reports and then custom reports. You can then select the report you have downloaded and heh presto
Wed, Aug 1 2007 4:53 PM

blakmk said:

Do you have a version of this report that runs against 2000 databases?
Fri, Sep 28 2007 5:41 PM

simonsabin said:

In Management studio Right click on a database, select reports and then Custom Report Browse to where you downloaded the file to and select the file. Acknowledge the warning you might get You only need to it the first time you run the report
Sun, Jan 25 2009 11:07 AM

dtspinella said:

I am also having an issue using this custom report. If I right click on my database in the Object Explorer I do not see any option for Reports - I see options for Script As, Properties etc... Thanks
Wed, Feb 4 2009 6:30 PM

dtspinella said:

Found out my issue. I had not applied SP2 that made the difference. Now I can run reports.
Thu, Feb 5 2009 5:13 PM

ChrisAVWood said:

Simon, What permission is needed to produce this display? We are always using a sysadmin but wanted to know how we could get other users to run it when they are db_owners of the database? Thanks Chris
Thu, Oct 29 2009 6:24 PM
Powered by Community Server (Commercial Edition), by Telligent Systems