Iteration #1:
SELECT * FROM sys.dm_os_enumerate_fixed_drives;
Msg 3634, Level 16, State 1, Line 3
The operating system returned the error '21(The device is not ready.)' while attempting 'GetDiskFreeSpace' on 'A:\'.
Workaround: You can disable the virtual Floppy drive from the Device Manager and re-run.
Iteration #2:
SELECT * FROM sys.dm_os_enumerate_fixed_drives;
As you can see there are duplicate records being returned from this new DMV and Microsoft will address that.
Note: This new DMV is a replacement for XP_FIXEDDRIVES.
Positioned Resources:
|
|
|
|
|
|