Having read the following :
How to identify your SQL Server version and edition
How to obtain the latest SQL Server 2000 service pack
Service Pack 4 for Microsoft SQL Server 2000
Cumulative list of the hotfixes that are available for SQL Server 2000 SP4
A cumulative hotfix package is available for SQL Server 2000 Service Pack 4 build 2187
Which appears to indicate
8.00.760 = sp3/sp3a
8.00.2039 = sp4
8.00.2187 = Cumulative rollup
8.00.2249 Final patch build number
I still have the following question which i would very much appreciate help in answering:
If support is required from Microsft what is the acceptable level of SQL Server patching before Microsoft will agree to look at a SQL Server problem. ?
SP4 Build 2039 + Build 2040 (awe fix)
SP4 Build 2187 cumulative rollup
SP4 Build 2249 fully patched as per KB894905
Do I need to apply builds 2187 to 2249 ?
If so where/how can I obtain the down loads from ( 8.00.2187 - 8.00.2249) ?
Have logged a call with microsoft support but as yet no responce.
Basically you should be on SP4:
Although you should really test to see if your issue is resolved on the cumulative update (2187).
'Fully patched' is whatever the minimum service pack level MS will support as defined in that document above, plus whatever patches you need to have applied if you have seen issues that need patching. In other words, if SP4 is the minumum supported version than that's all you need, unless you're running into issues that have been fixed in a post SP4 patch.
2249 was the last hotfix build and the product has entered a phase in its lifecycle where it's not going to get any more hotfixes unless security or corruption issues are uncovered and SQL 2000 hotfixes are only available via MS support. Don't apply hotfixes for the sake of applying them. Only apply them if you know it fixes an issue you're running into.
Hmmm ... this is what collegues have alluded to ... but its good have it confirmed - thanks Ajmer.
... the thought of waiting till you have a known errors occure before you patch fills me with dread esp in production environments.
... Some of these Fixes don't look that obscure.
(KB899761 (http://support.microsoft.com/kb/899761/) ...
FIX: Not all memory is available when AWE is enabled on a computer that is running a 32-bit version of SQL Server 2000 Service Pack 4 )
is a know issue and with awe enabled the microsoft recommendations are clearly to apply it.
So I guess the choices have narrowed to :
SP4_8.00.2039+8.00.2040 - downloadable
SP4_8.00.2039+8.00.2187(which includes Build 2040 (KB899761) ) also downloadable
Whats is the common practice here ?.
Why do microsoft offer a cumulative rollup if the advise is to stick to just applying the individual fixes to individual errors ?.
If you have more than 4GB installed on your server and it's awe enabled then of course you'd want the 2040 patch; like I said, if you know your issue is fixed in a patch then apply the patch.
CUs are a recent 'innovation' as prior to build 2187 it was just hotfixes and SPs.
You're better off applying a cumulative update (CU) containing that hotfix, given the choice of a straight hotfix or subsequent CU, as the CUs do tend do go through a more enhanced testing phase (as well was being an accumulation of a number of hotfixes).
The point to stop patching is the point at where you're on a supported SP level and not running into any issues requiring a patch. If that happens to be what you perceive as being an old build than so be it - wouldn't you rather be running on a stable 'older build' platform than explaining to users why they suffered downtime because one of your SQL installations suddenly ran into issues after applying a patch that wasn't really needed? (Of course, you'd have tested it thoroughly on a test/staging env first, but...)
Please make sure you check the end of life documentation for SQL Server 2000. We recently called MS on a Premier Support Contract about a SQL Server 2005 SP1 server. They did NOT want to support it!
As far as I know SQL 2000 was end of life as of April 8. 2008. This was directly from the MS support site and confirmed by our TAM. They will offer extended support for $40,000 per incident.
My advice: If you can get up to 2005, do it. Especially if it's a production environment where you may possibly need MS support.
We went as far as rolloup 2187 in the end
I come accross this very usefull website during my investigations which i found very helpfull
"A hotfix package does not replace a service pack. A hotfix package is optional. A hotfix package can be installed or uninstalled at any time. Additionally, hotfix packages are cumulative. Therefore, the latest OD hotfix package or CU hotfix package includes all previously released hotfixes."
This is from http://support.microsoft.com/kb/935897 which explains Microsoft's model for updates to SQL Server.
I'm not sure that MS won't support SQL 2000 any more. This is because today they are assisting us with an issue and I believe we will have to apply the hotfix to our SQL 2000 server. It did not cost $40k for this incident.
All I can say is attempt to call them and roll the dice. Maybe we got lucky or perhaps its a ploy to get everyone to SQL 2005/2008. In any case, if you have the ability create free cases, see if you can open one for a SQL2000 box. We did and they even accepted my free (2) incidents from technet. So we got lucky.
We are experiencing a problem while using Idera Diagnostic Monitor and have opened cases both with Idera and MS. Both point the finger at each other but I hope the hotfix will resolve this issue.
For more informarion about the support life cycle of SQL Server 2000 is mentioned here:
Make sure you upgrade to a supported version within the standard support timeframe as main stream support ended in 2008 (April). Extended support has to be paid and be available till 2013. For more qustions see the information on the site.
Jens K. Suessmeyer