TechNet
Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

sys.dm_os_windows_info (Transact-SQL)

 

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

Returns one row that displays Windows operating system version information.

Column nameData typeDescription
windows_releasenvarchar(256)Microsoft Windows operating system release (version number). Cannot be null. For a list of values and descriptions, see Operating System Version (Windows). Cannot be null.
windows_service_pack_levelnvarchar(256)Service pack level of the Windows operating system. Cannot be null.
windows_skuintWindows Stock Keeping Unit (SKU) ID. Cannot be null. For a list of SKU IDs and descriptions, see GetProductInfo Function. Is nullable.
os_language_versionintWindows 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

Requires VIEW SERVER STATE permission on the server.

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

sys.dm_os_sys_info (Transact-SQL)

Community Additions

ADD
Show:
© 2016 Microsoft