SQL Server Version mismatch

Medina, Alex 21 Reputation points
2021-06-08T12:37:48.397+00:00

Hello, please help me understand this

I have SQL Server 2016 installed.
When using @@Version I get (SP2-CU17) (KB5001092) - 13.0.5888.11 but when checking on the registry key HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\130\SQLServer2016\CurrentVersion I get 13.2.5888.11.

I have tried to check the internet for 13.2.5888.11, but it looks like it does not even exists :(, is this an error in the registry or maybe the entry is corrupted? is there a way to fix the registry? or the version in SQL?

Thanks in advance!

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,492 questions
0 comments No comments
{count} votes

Accepted answer
  1. Olaf Helper 47,426 Reputation points
    2021-06-08T12:53:16.357+00:00

    See https://sqlserverbuilds.blogspot.com/, build 13.0.5888.11/13.2.5888.11 is "Cumulative update 17 (CU17) for SQL Server 2016 Service Pack 2 " = Latest CU

    The 2 as major build number is often use for the tools, 0 for the engine; it's explain under the link above.


1 additional answer

Sort by: Most helpful
  1. Tom Phillips 17,771 Reputation points
    2021-06-08T18:42:39.72+00:00

    Do not use the registry to verify your version. Always use SELECT @@VERSION. The version numbers reported by @@VERSION do not match the key put into the registry.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.