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