DMV – Windows Operating System version information

You can use the DMV on SQL 2008 R2 and above to query Windows OS information SELECT * FROM sys.dm_os_windows_info References: MSDN: http://msdn.microsoft.com/en-us/library/hh204565.aspx Related Forum thread: http://social.msdn.microsoft.com/Forums/en-US/sqltools/thread/9753f897-82e3-4602-b7c9-650c7239e83d