August 4, 2008 at 3:41 pm
Is there an easy way to determine WHAT hotfixes have been applied to a SQL Server 2000 database?
A client installed SP4, then a custom hotfix that Microsoft created for us.
However, they were supposed to have installed a post-SP4 rollup fix first.
The version number is updated to match the custom hotfix. So, I need a way to determine if they did / did not install the earlier KB hotfix.
August 4, 2008 at 4:19 pm
SQL Server hot fixes are accumulative, so if the running version is 8.00.2148 , then you know that hot fixes 2147 , 2145 , 2050 and 2040 have been applied.
There a cross reference of SQL Server versions at http://www.sqlsecurity.com/FAQs/SQLServerVersionDatabase/tabid/63/Default.aspx
SQL = Scarcely Qualifies as a Language
August 10, 2008 at 4:59 pm
As Carl mentioned, each hot fix includes the fixes of all items before it (all previous hot fixes). This is because the latest build is used to add the new fixes to it.
This also means that if you apply a hotfix, you should be aware of what other items are being changed/patched in case previous fixes cause problems.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply