SQLTeam.com | Weblogs | Forums

OS version


#1

Hello,

How can fins os version from sql-server, I use "SELECT @@VERSION" and result is here:

Microsoft SQL Server 2012 - 11.0.2100.60 (X64) **
** Feb 10 2012 19:39:15 **
** Copyright (c) Microsoft Corporation

** Enterprise Edition (64-bit) on Windows NT 6.2 (Build 9200: )**

But "Windows NT 6.2 (Build 9200: )" can be windows 8 also windows server 2012 ?

sasan.


#2

did you google it? I got this on my first try:

sys.dm_os_windows_info

Plus:

Windows versions


#3

Hi,

sql server using for web housting, so I have not access to sys.
instead I using EXEC xp_msver 'WindowsVersion' result is here:

Index Name Internal_Value Character_Value


15 WindowsVersion 602931718 6.2 (9200)

But I wote later, 6.2 (9200) use for both windows 8 and windows server 2012,
Is possible to find exact windows name from Internal_Value 602931718 on above query result.

Thanks,
sasan.