October 24, 2005 at 1:10 pm
How can I see the visual representation of database space in Yukon, like we do now in sql 2000?
I don't see it in properties, or anywhere else.
Thanks
October 24, 2005 at 2:59 pm
In SSMS there is a window called Summary. This window has a button called Report that can drop down into a list of available reports. The set of reports change depending on what part of the object tree currently has context. If you select a database in object tree and open the list of reports, there will be a report called Disk Usage. This report should give you what you need.
October 25, 2005 at 8:38 am
Awesome, thanks. Looks like it's using Reporting Services
December 16, 2007 at 1:28 am
Thank you
December 17, 2007 at 10:52 am
Hi Chris,
I cannot use those reports on one of my servers because the application vendor requires their databases to be in SQL 2000 (80) compatibility mode. Can you point me to an alternative, such as how to get DB file and Log file usage via a query?
Thanks much!
Marck
December 17, 2007 at 3:04 pm
Check this thread - there's several scripts posted: http://www.sqlservercentral.com/Forums/Topic432483-146-1.aspx
MARCUS. Why dost thou laugh? It fits not with this hour.
TITUS. Why, I have not another tear to shed;
--Titus Andronicus, William Shakespeare
December 17, 2007 at 6:39 pm
For anyone reading this thread and using SQL 2005 who can't find the reports - they are introduced with SP2.
-SQLBill
December 18, 2007 at 2:53 am
Do a Google search on: custom report sql 2005
There is a Taskpad View report on sqlblogcasts, and other reports can be found elsewhere.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply