sys.dm_os_windows_info (Transact-SQL)

Returns one row that displays Windows operating system version information. This dynamic management view is valid for SQL Server 2008 R2 SP1 and later versions.

Column name

Data type

Description

windows_release

nvarchar(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_level

nvarchar(256)

Service pack level of the Windows operating system. Cannot be null.

windows_sku

int

Windows Stock Keeping Unit (SKU) ID. Cannot be null. For a list of SKU IDs and descriptions, see GetProductInfo Function. Is nullable.

os_language_version

int

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.

Security

Permissions

Requires VIEW SERVER STATE permission on the server.

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