Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest SQL, Fabric and Power BI learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Starting with SQL Server 2017 (14.x) CU 1, sys.dm_os_enumerate_fixed_drives
enumerates volumes mounted to drive letters like C:\
.
Column name | Data type | Description |
---|---|---|
fixed_drive_path |
nvarchar(512) | Path to the volume, like C:\ . |
drive_type 1 |
int | Code for drive type. |
drive_type_desc 1 |
nvarchar(512) | Description of drive type. |
free_space_in_bytes |
bigint | Disk free space in bytes. |
1 For more information, see the GetDriveTypeW function.
For SQL Server 2019 (15.x) and previous versions, requires VIEW SERVER STATE permission on the server.
For SQL Server 2022 (16.x) and later versions, requires VIEW SERVER PERFORMANCE STATE permission on the server.
Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest SQL, Fabric and Power BI learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register today