Viewing 2 posts - 1 through 2 (of 2 total)
Good catch! Here is updated logic...
EXEC @x = sp_OACreate 'Scripting.FileSystemObject', @iFSO OUT
IF @x <> 0
RETURN -1
EXEC @x = sp_OAMethod @iFSO, 'GetDrive', @iDrive OUT, @cDrive
GOTO Error
EXEC @x =...
November 29, 2011 at 11:01 am
#1414255
----The following will return each local drive and a free space in MBEXEC master.dbo.xp_fixeddrives
----The following function with obtain a supplied drive's capacity
ALTER FUNCTION [dbo].[fnDBDriveStats_GetDriveSize]
(@cDrive char(1)) ...
December 7, 2007 at 9:04 am
#758136