|
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;
http://
http://
Contributed by:
Rohit kakria
I am software developer
Resourse address on xpode.com
http://www.xpode.com/Print.aspx?Articleid=128
Click here to go on website
|