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