Xpode.com        Click here to Print this article.

Get the total space of all databases

This query tells the total number of space covered by the all databases of sql server. Copy and paste this query in query analyzer.

SELECT SUM(size*8192.0) AS totalsize FROM sys.master_files;


Contributed by:
Rohit kakria
I am software developer

Resourse address on xpode.com

Click here to go on website