One more quick introduction to DMV for Denali. Following DMV provides information about Windows Operating System. Here is the quick example of the same. The DMV is called sys.dm_os_windows_info.
This DMV returns information about the operating system volume (directory) on which the specified databases and files are stored. Here is the quick example I have created for the same.
SELECT *
FROM sys.dm_os_windows_info;
Here is the screenshot of the same:
Here is my question back to you – where would you use this stored procedure in your application? What is your preferred method to know details about Windows? One last question – what is 1033 in the last column of the table result and what is 1033 represent?
Published by Pinal Dave on SQLAuthority. More of my work at pinaldave.com.
8 Comments. Leave new
The DMV returns the Win OS info. The last column represents the locale information. 1033 for English.
probably use it to detect the OS language settings and 1033 is the operating system language (via wmi) 1033 = oslanguage us english
SELECT *
FROM sys.dm_os_windows_info; is not working in my sqlserver why plz reply
Ensure you are using Denali.
1033 represent the “English” language setting.
Ensure you are using Denali
sorry, sudeepta, actually it is not intended for u. Accidentally replied
Hi Pinal,
This DMV is also available on SQL Server 2008 R2 SP1.
Regards,
Marcos Freccia