Use

'xp_fixeddrives' to get free space on disks.

Regards,

Sean Rodgers
Welldata Ltd

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



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