October 25, 2002 at 2:18 pm
Is there any built-in st. proc to return the size of all databases in a SQL-Server 7. Thanks.
October 25, 2002 at 2:46 pm
sp_helpdb
Steve Jones
http://qa.sqlservercentral.com/columnists/sjones
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
October 26, 2002 at 4:27 pm
Thanks for your reply. If I may ask one more question, how I can collect the max and used size of all databases ?
October 27, 2002 at 1:10 pm
This is a neat way of doing it
sp_msforeachdb '?..sp_spaceused'
Simon Sabin
Co-author of SQL Server 2000 XML Distilled
http://www.amazon.co.uk/exec/obidos/ASIN/1904347088
Simon Sabin
SQL Server MVP
http://sqlblogcasts.com/blogs/simons
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply