[dbo].[usp_bpcheck] :: does not accurately detect MS Windows 2012

[DanielAdeniji]

When deriving Windows Version, there is a piece of code that lumps windows release 6.3 and 10.0 together and sets it equal to 10.0.

In SQL Server Version 11 thru 14, there is an additional check to ensure this only occurs for the following builds:-

a) 10586 b) 14393

For builds 14 and later this additional check is skipped.

Skipping the build check means that MS Windows 2012 is not properly identified.

Tested against @@VERSION Microsoft SQL Server 2017 (RTM-CU13) (KB4466404) - 14.0.3048.4 (X64) Nov 30 2018 12:57:58 Copyright (C) 2017 Microsoft Corporation Enterprise Edition: Core-based Licensing (64-bit) on Windows Server 2012 R2 Standard 6.3 <X64> (Build 9600: ) (Hypervisor)

[DanielAdeniji]

versionOS.txt Attaching test code.