HiveBrain v1.2.0
Get Started
← Back to all entries
patternsqlMinor

SQL Server Version - are hotfixes for previous versions implied?

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
previoussqlversionhotfixesareimpliedforversionsserver

Problem

tl;dr: If I identify an SQL Server as having build X, and find out that X implies hotfix Y, does it also imply that all hotfixes listed for versions below X are installed? Or that only the hotfix for build X is installed?

I found the following list of Microsoft SQL Server version numbers and their meaning in terms of service packs, hotfixes, product versions, etc.:

  • SQL Server Version Database @ sqlsecurity.com



My question is best illustrated with an example, an excerpt from that list:

2005 RTM+Q915793        9.00.1502  <-- interested in this
2005 RTM+Q910416        9.00.1500
2005 RTM+Q932557        9.00.1406


In the above list, if I find out that the SQL Server I am connected to is version 1502, does this imply that:

  • only hot-fix Q915793 is installed?



  • or that all of hot-fixes Q915793, Q910416 and Q932557 are installed?



ie. does the build imply that all previous hotfixes are installed?

Follow-up bonus question: Is this a fixed pattern for all the versions, or are there exceptions to the rule?

Solution

All hotfixes are cumulative unless otherwise stated.

Random pick, http://support.microsoft.com/?Kbid=971409


Because the builds are cumulative, each new fix release contains all the hotfixes and all the security fixes that were included with the previous SQL Server 2005 fix release. Microsoft recommends that you consider applying the most recent fix release that contains this hotfix.

The "otherwise stated" is like these examples where you have some dependencies (sorry. bit old, for SQL Server 2000 and SP4). http://support.microsoft.com/?Kbid=941203 and http://support.microsoft.com/kb/959420

Context

StackExchange Database Administrators Q#4218, answer score: 6

Revisions (0)

No revisions yet.