LinkedIn | FaceBook | Twitter
These are database-level reports and you can find them by starting SQL Server Management Studio and right-clicking a database name. From the menu that appears, click the Standard Reports, and then select either of them.
Here are the columns you’ll get in these reports:
I right click on one of my user dbs and I don't see that option. Do you have to have ssrs installed, perhaps?
rtorres - no, but you do need SSMS 2005 SP2 or higher.
you can't be in 2000 compatibility mode either
When i select a standard report - i don't get the report for that database. Most reports on any database seem to point back to the same database - Is there a way to edit the standard reports?
Pete - you can't edit the standard ones, but you can create your own.
I have a default database defined on my registered servers. We are finding that the Disk Usage by Table then appears to only work for the default database although the title of the report will indicate the database that you right click on. Sounds like a bug to me, you shouldn't have to change your default database to default for this report to run.