My client has around 200 SQL Server instances running on SQL Server 2000, 2005 and 2008. We have agreement to apply the patching of the SQL Server Instances Quarterly.
The question here is there are some SQL Server 2000 instances running on SP4 with version 8.00.2039. On these SQL Server 2000 instance, client not interested on upgrading it. However client asks to apply any patching on it.
1. Is there any mandatory hotfixes exists for SQL Server 2000 running on SP4?
2. How do we know and where can we find if any mandatory patch or hotfixe exists for SQL Server 2000, 2005 and 2008?
3. I have collected the detail across the web, is that below details correct?
SQL Server Build Version Patch Level
SQL Server 2000 8.00.2039 2000 SP4
SQL Server 2005 9.00.4226 2005 SP3+Q970279 (Cumulative HF 4)
SQL Server 2008 10.00.2714 2008 + Cumulative Update 2 for SP1
Is there any specific Patch level, do we have to maintain SQL Server 2000, 2005 to upgrade to SQL Server 2005 or 2008?
Is the Microsoft support based on SQL Server version running at Service Pack level or specified patch level?
Sivaprasad S - [ SIVA ]http://sivasql.blogspot.com/