October 2, 2009 at 2:29 pm
Currently my system is running sql 2000 sp4 with build 2195.
There is one script we run to generate the report. It was running fine till 2 weeks ago. From last week we are having the issue with this script either we are getting the timeout with expired error message or the output file has the incosistent errors such as some time it give few white spaces or some times miss bunch of records. Do anyone know what's wrong? Should I install the hot fixes below?
Any help would be appreciated!
- 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
October 2, 2009 at 2:44 pm
As this looks like a performance issue, please read the second article I have referenced in my signature block. Following the instruction in that article will get you the best help in this situation.
October 2, 2009 at 2:57 pm
Can you send me the link of your blog?. Thanks
October 2, 2009 at 2:59 pm
The link to the aforementioned article is located in my signature block below. It is the second article.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply