http://authors.aspalliance.com/stevesmith/articles/db_info.asp

this helps.....

Sandeep

******************************************************
Sandeep Kataria
University of Minnesota Cancer Center,
Suite 310 Dinnaken Office Building,
925 Delaware St. SE
Tele: (612) 624-3994 | Fax: (612) 624 1057
Pager: (612) 899-6649
Text Msg: [Email Address Removed] & CONFIDENTIALITY NOTICE: This e-mail message, including any
attachments, is for the sole use of the intended recipient(s), and may
contain business confidential and privileged information. Any unauthorized
review, use, disclosure or distribution is prohibited. If this e-mail was
not intended for you, please notify the sender by reply e-mail that you
received this in error. Destroy all copies of the original message and
attachments.


-----Original Message-----
From: Hugh du Toit [mailto:[Email Address Removed]
Sent: Thursday, April 29, 2004 09:14
To: LazyDBA.com Discussion
Subject: RE: Database MDF, LDF File Sizes[Scanned]

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