sys.dm_os_windows_info (Transact-SQL)

  • Artikel

Applies to: SQL Server - Windows only

Returns one row that displays Windows operating system version information.

Only applies to SQL Server running on Windows. To see similar information for SQL Server running on a non-Windows host, such as Linux, use sys.dm_os_host_info (Transact-SQL). Behavior on a non-Windows host is undefined.

Column name Data type Description
windows_release nvarchar(256) For Windows, returns the release number. For a list of values and descriptions, see Operating system version (Windows). Can't be NULL.
windows_service_pack_level nvarchar(256) For Windows, returns the service pack number. Can't be NULL.
windows_sku int For Windows, returns the Windows Stock Keeping Unit (SKU) ID. For a list of SKU IDs and descriptions, see GetProductInfo function. Can be NULL.
os_language_version int For Windows, returns the Windows locale identifier (LCID) of the operating system. For a list of LCID values and descriptions, see Locale IDs assigned by Microsoft. Can't be NULL.

Permissions

On SQL Server 2019 (15.x) and earlier versions, the SELECT permission on sys.dm_os_windows_info is granted to the public role by default. If revoked, you require VIEW SERVER STATE permission on the server.

On SQL Server 2022 (16.x) and later versions, you require VIEW SERVER PERFORMANCE STATE permission on the server.

Limitations

To see information for SQL Server running on a non-Windows host, such as Linux, use sys.dm_os_host_info (Transact-SQL). Behavior on a non-Windows host is undefined.

Examples

The following example returns all columns from the sys.dm_os_windows_info view, on Windows Server 2019 Standard:

SELECT windows_release,
    windows_service_pack_level,
    windows_sku,
    os_language_version
FROM sys.dm_os_windows_info;

Here's the result set.

windows_release windows_service_pack_level windows_sku os_language_version
10.0 7 1033

Related content