[sourcecode language=”sql”]SELECT windows_release, windows_service_pack_level,
windows_sku, os_language_version
FROM sys.dm_os_windows_info OPTION (RECOMPILE);
[/sourcecode]
– Gives you major OS version, Service Pack, Edition, and language info for the operating system