product version result

Question

product version result

mtz676

SSCrazy Eights

Points: 9212
More actions
October 28, 2020 at 3:26 pm

#3802122
SELECT
SERVERPROPERTY ('ProductVersion')
Output: 13.0.4001.0
What does each of those numbers mean.I need to find the most recent hotfixes applied on a server.
Is 4001 the most recent hotfix applied
13 signifies sql 2016
First '0' is it sp1 ??
And what the last '0' signify ?
SELECT substring(SERVERPROPERTY ('ProductVersion'),6,4)..this results in an error . how do i extract only 4001 from hte result.
I tried: SELECT substring(SERVERPROPERTY ('ProductVersion'),6,4)
Error:
Msg 8116, Level 16, State 1, Line 1
Argument data type sql_variant is invalid for argument 1 of substring function.
select convert(varchar(1000),SERVERPROPERTY('Product version')) --This returns a NULL
Got it:
SELECT SUBSTRING(CAST(SERVERPROPERTY('ProductVersion') as nvarchar(128)),6,4)
returns 4001
Is 4001 the hot fix ?
- This topic was modified 4 years ago by mtz676.
- This topic was modified 4 years ago by mtz676.
- This topic was modified 4 years ago by mtz676.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Thom A SSC Guru Points: 99130 More actions · Answer 1

You can find a list of the build numbers, for all versions, here. In recently history, the only version that have had a "major" version revision is SQL Server 2008 with SQL Server 2008R2 (which was Version 10.50 instead of 10.0). Otherwise there isn't a specific method to Microsoft's version number that appears to be easily discernable apart from that, previously, the minor version when the to next thousand for each SP (which is no longer applicable for SQL Server 2017+).

Thom~

Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk

Steve Jones - SSC Editor SSC Guru Points: 736212 More actions · Answer 2

These are build numbers, so depending on how many builds go through the MS system, you get different numbers for different patches. There is no code for the number itself, other than the first part, which is the major version.

We also maintain build numbers here at SSC: https://www.sqlservercentral.com/articles/sql-server-build-lists

Jonathan AC Roberts SSCoach Points: 18354 More actions · Answer 3

https://support.microsoft.com/en-us/help/3177312/kb3177312-sql-server-2016-build-versions

SQL Server 2016 Service Pack 1 (SP1) Cumulative Update (CU) Builds

SP1 13.0.4001.0 KB3182545 November 16, 2016