SQL Server Performance Forum – Threads Archive
Clean installation…patch…I just performed a clean installation of SQL Server 2000 with SP3a so I am running version 8.00.760. What hotfix level do you recommend I install up to? Thanks…
This is my own personal opinion, but I don’t like to install Hotfixes unless I have a specific need for one. On the other hand, there is the philosophy that you should always be up to date. I think each points of view can be valid. If you do decide to install Hotfixes, I would be sure to thoroughly test the server to ensure it is working as expected. —————————–
Brad M. McGehee, MVP
I recommend taking it to 8.00.818, that’s a cumulative hotfix (I think it’s MS03-024 off the top of my head), contains a fix for problem with the UMS getting hung and includes better diagnostics if a UMS hangs (that’s a User Mode Scheduler – if one hangs, your whole server grinds to a halt). I have found this very problem to crop up on several of my servers and this fix does alleviate it. It also contains some security fixes. But otherwise, I’m like Brad, I don’t hotfix servers unless they’re broken. Tom Pullen
DBA, Oxfam GB
Agree. I apply fix only when I need it.
SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.
For ease of your doubt you can test the hotfix in development environment and work the application, if nothing turned out spurious then you may plan to deploy on production box. HTH Satya SKJ
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.
The latest security related hotfix after SP3a is 8.00.0818 (then there is 8.00.0819 that fix an issue with 818.) MS03-031: Security Patch for SQL Server 2000 Service Pack 3
http://support.microsoft.com/default.aspx?scid=kb;EN-US;821277 FIX: You Are Prompted for Password Confirmation After You Change a Standard SQL Server Login
(Updates Semobj.dll to 8.00.819. Fixes a bug with the 8.00.818 patch)