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