Click here to hide categories Click here to show left categories

User: Home          welcome : Guest          Log In / Register here     




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;
Share this article   |    Print    |    Article read by 2805 times
Author:
Rohit kakria
I am software developer
Related Articles: No related article
Related Interview Questions: No related interview question