October 2, 2009 at 9:35 am
Currently my system is running sql 2000 sp4 with build 2195 and I need to install the hotfix (SQL Server 2000 build 8.00.2223) to fix some timeout issues. Should I install all the other sequential hot fixes from 2196 through 2222 or 2223 will cover all the other fixes? Can you also please send me the steps to install the hotfix? Do I have to start the sql services after the install?
October 2, 2009 at 10:02 am
This is not a CU, just a hotfix.
From http://support.microsoft.com/kb/925419/:
Hotfix file information
This hotfix contains only those files that are required to correct the issues that this article lists. This hotfix may not contain all the files that you must have to fully update a product to the latest build.
As far as how to install, and whether services have to be restarted, I would read any README files that come from downloading the hotfix:
http://support.microsoft.com/hotfix/KBHotfix.aspx?kbnum=925419&kbln=en-us
Followed by first testing on a dev or test environment built to the same level. I would ALWAYS bet on restarting the services, just in case. Expectation Management 😉
MJM
October 2, 2009 at 2:24 pm
PLEASE HELP-
The script is timing out with expired error and also the following-
When the script runs to out put the file on other server, the output errors are incosistent, either its generating the corrupted output with Whitespace or missing some records. The system timeouts/pause then continue to run. Should I install the following patches to fix the issue.
- SQL Server 2000 build 8.00.2197
919068 (http://support.microsoft.com/kb/919068/ ) FIX: The query may return incorrect results, and the execution plan for the query may contain a "Table Spool" operator in SQL Server 2000
919133 (http://support.microsoft.com/kb/919133/ ) FIX: Each query takes a long time to compile when you execute a single query or when you execute multiple concurrent queries in SQL Server 2000
- SQL Server 2000 build 8.00.2223
925419 (http://support.microsoft.com/kb/925419/ ) FIX: The server stops responding, the performance is slow, and a time-out occurs in SQL Server 2000
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply