THE ABOVE SCRIPT WILL GIVE THE SIZE OF ALL DATABASES INCLUDING THE SYSTEM AND USER DATABASE , BUT THE MIRRORING DATABASES WILL NOT BE REFLECTED IN THE LIST.

 

THE SCRIPT GIVES THE TOTAL DATA UITLISATION TOTAL DATA LEFT AND TOTAL SPACE LEFT IN LOG,

AND THE PERCENTAGE OF UTILISATION.

THE ZERO SAPCE UTILISED MEANS THE THE UTILISATION OF THE DATA OR LOG IS LESSTHAT THE ZERO.

 

THE SCRIPT CREATE A TEMPRORAY TABLE TO STORE THE DATA AND A UNDOCUMENTED PROCEDURE OF MICROSOFT SP_MSFOREACHDATABASES