One more quick introduction to DMV for Denali. Following DMV provides information about Windows Operating System. Here is the quick example of the same.
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.
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?
Reference: Pinal Dave (http://blog.SQLAuthority.com)