Skip to content

sys-dm-os-windows-info-transact-sql.md

Latest commit

 

History

History
69 lines (53 loc) · 3.31 KB

sys-dm-os-windows-info-transact-sql.md

File metadata and controls

69 lines (53 loc) · 3.31 KB
title sys.dm_os_windows_info (Transact-SQL) | Microsoft Docs
ms.custom
ms.date 03/30/2017
ms.prod sql-non-specified
ms.reviewer
ms.suite
ms.technology
database-engine
ms.tgt_pltfrm
ms.topic language-reference
f1_keywords
dm_os_windows_info
dm_os_windows_info_TSQL
sys.dm_os_windows_info
sys.dm_os_windows_info_TSQL
dev_langs
TSQL
helpviewer_keywords
sys.dm_os_windows_info dynamic management view
ms.assetid adc81283-fdc2-46c0-bb48-abe82bbf2459
caps.latest.revision 15
author JennieHubbard
ms.author jhubbard
manager jhubbard

sys.dm_os_windows_info (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx_md]

Returns one row that displays Windows operating system version information.

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

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). Cannot be NULL.
windows_service_pack_level nvarchar(256) For Windows, returns the service pack number. Cannot 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. Is NULLable.
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. Cannot be NULL.

Permissions

The SELECT permission on sys.dm_os_windows_info is granted to the public role by default. If revoked, requires VIEW SERVER STATE permission on the server.

Limitations and Restrictions

To see informaton for SQL running on a non-Windows host, such as Linux, use sys.dm_os_host_info (Transact-SQL).

Examples

The following example returns all columns from the sys.dm_os_windows_info view.

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

Here is a sample result set.

windows_release windows_service_pack_level windows_sku os_language_version

--------------- --------------------------- ------------ -------------------

6.0 Service Pack 2 4 1033

See Also

sys.dm_os_sys_info (Transact-SQL)
sys.dm_os_host_info