KB178225 - FIX: SQL Server 6.5 Service Pack 4 fixlist

Article ID: 178225

Article Last Modified on 12/17/2004

Microsoft SQL Server 6.5 Standard Edition

This article was previously published under Q178225

SUMMARY

The following is a list of fixes and other various improvements that have been made in the Microsoft SQL Server version 6.5 Service Pack 4. For more information, contact your primary support provider.

Please note that workarounds described in these articles have been provided for your information only. It is not necessary to implement these workarounds if you have the updated software.

For more information about each corrected problem in SQL Server version 6.5 Service Pack 4, use the Qxxxxxx number to query for the article in the Microsoft Knowledge Base.

To download the service pack, see the following article in the Microsoft Knowledge Base:

178295 : INF: How to Obtain SQL Server 6.5 Service Pack 4

LIST OF PROBLEMS CORRECTED IN SERVICE PACK 4

Q175887  FIX: Msg 1203 & SQL Server May Be Shut Down w/ Large Cursor Row
Q175546  FIX: Trace Flag 1211 Does Not Work Properly
Q175303  FIX: Database Usage Count Does Not Return to Zero
Q175143  FIX: Err 1203 If Deadlock Occurs During Concurrent ORDER BY DESC
Q175097  FIX: Non-Optimal Performance for Views Defined with a Subquery
Q174512  FIX: A Stored Procedure or Trigger May Cause Error 707 or an AV
Q174479  FIX: Lazywriter Access Violation During DUMP Activity
Q174221  FIX: Text Col. Update Through Cursor > 1,988 Bytes Gets Err. 702
Q174085  INF: Enhancement to Trace Flag 1140
Q173932  FIX: Heavy Stress on Tempdb w/ Multi-CPU Computer May Cause AVs
Q173215  FIX: COMMIT TRAN Statement May Fail with Msg 602
Q172557  FIX: Lazy Writer Process May Cause an Access Violation
Q172549  FIX: T-SQL Cursors Ignore NOCOUNT Query Option & Trace Flag 364
Q171865  FIX: UPDATE with FORCEPLAN ON May Cause Error 806 in Tempdb
Q171369  FIX: Delete/Insert on Table with Text/Image May Cause Error 38
Q170508  FIX: Blocking Lock Remains or Server Stops After Heavy Deadlock
Q170507  FIX: READTEXT May Fail w/ Msg 7134 If Hard Coding Text Pointer
Q170499  FIX: Unhandled AV During Concurrent DUMP DATABASE Commands
Q170437  FIX: Multi-Session DBCC OUTPUTBUFFER Under Stress Causes AV
Q170436  FIX: Infrequent Access Violation During LOAD TRANSACTION
Q170090  FIX: Recovery May Fail w/Error 6902 and Mark Database as Suspect
Q155710  FIX: Select Statement Can Cause Arithmetic Overflow

Additional query words: sp sp4 fix list bug ftp servpack patch sqlfaqtop

Keywords: kbinfo kbfix KB178225