We have most of our servers using mount points and we have weekly disk space reports generated. One of my friends environment has started using mount points and slowly the number of servers using mount points is expected to grow. The traditional ways of getting total space and available space from disk drives do not
Read More »

— To allow advanced options to be changed. EXEC sp_configure ‘show advanced options’, 1 GO — To update the currently configured value for advanced options. RECONFIGURE GO — To enable the feature. EXEC sp_configure ‘xp_cmdshell’, 1 GO — To update the currently configured value for this feature. RECONFIGURE GO DECLARE @sqlver sql_variant DECLARE @sqlver2 varchar(20)
Read More »