Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Returns one row that displays Windows operating system version information.
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