Hi Rahim,

Just use a sp_helpdb 'database_name' and that should sort you out.


-----Original Message-----
From: Rahim [mailto:[Email Address Removed] 29 April 2004 03: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] email and any accompanying attachments may contain confidential and proprietary information. This information is private and protected by law and, accordingly, if you are not the intended recipient, you are requested to delete this entire communication immediately and are notified that any disclosure, copying or distribution of or taking any action based on this information is prohibited.

Emails cannot be guaranteed to be secure or free of errors or viruses. The sender does not accept any liability or responsibility for any interception, corruption, destruction, loss, late arrival or incompleteness of or tampering or interference with any of the information contained in this email or for its incorrect delivery or non-delivery for whatsoever reason or for its effect on any electronic device of the recipient.

If verification of this email or any attachment is required, please request a hard-copy version.
********************
MS Sql Server LazyDBA home page