Can only help with one part:

dbcc sqlperf(logspace) --> show log size and % space used by each db

-----Original Message-----
From: Rahim [mailto:[Email Address Removed] 29 April 2004 15:07
To: LazyDBA.com Discussion
Subject: Database MDF, LDF File Sizes[Scanned]


Hi Friends,

Can anybody through some light or guide me or any readymade Procedure(s) to


1. Gets the all databases and respective Database mdf File Size and ldf file
Sizes
2. Database Server Hard Disk Total Space and Unused Space.

Thanks in Advance

rgds
K.Rahim
DBA.
*****************************************************************************************************
The information in this email is confidential and is intended solely for the addressee(s).
Access to this email by anyone else is unauthorized. If you are not an intended
recipient, you must not read, use or disseminate the information contained in this email.
*****************************************************************************************************

---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Get today's cartoon: http://www.LazyDBA.com
To unsubscribe, e-mail: mssqldba-[Email Address Removed] ,
then respond to the confirmation email you get
For additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page