I guess I can help with the rest
exec xp_fixeddrives
will give you disk space free
I use a continuously running job as below to watch my P drive and exec
a cdosys mail message to my pager when it gets below 6GB:

declare @MB_Free int
create table #FreeSpace(
Drive char(1),
MB_Free int)
insert into #FreeSpace exec xp_fixeddrives
select @MB_Free = MB_Free from #FreeSpace where Drive = 'p'

-- Free Space on F drive Less than Threshold
if @MB_Free < 6048
exec master.dbo.sp_send_cdosysmail

HOH
Brian Nordberg

>>> "Hugh du Toit" <[Email Address Removed] 4/29/2004 8:14:23 AM >>>
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]
Sent: 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]

---------------------------------------------------------------------
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