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 ?
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.