FIX: SQL Server 6.5 Service Pack 3 Fixlist

ID: Q169432

The information in this article applies to:

Microsoft SQL Server version 6.5 Service Pack 3 and later

SUMMARY

The following is a list of fixes and various other improvements that have been made in Microsoft SQL Server version 6.5 Service Pack 3. 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 3, 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:

Q166701 INF: How to Obtain SQL Server 6.5 Service Pack 3

============================================

LIST OF PROBLEMS CORRECTED IN SERVICE PACK 3

ODBC

Q164442 FIX: ODBC Clients Show as Sleeping but Command Is EXECUTE

Server

Q174443 FIX: Stranded Compile Time Table Created by a Failed SELECT INTO
Q170296 FIX: Deadlock on Table with Text/Image Column May Cause Errors
Q167779 FIX: Query Slow w/ ORDER BY DESC on Table w/ Composite Index
Q167336 FIX: A Full Outer Join with the Same Table May Cause an AV
Q167335 FIX: Invalid Text Handle Errors May Occur in Transactions
Q167334 FIX: Error Msg 201 Incorrectly Returned Twice
Q167333 FIX: SQL Server Stops Responding When Canceling Tape Backup
Q167332 FIX: Error 3201 Does Not Log a Message to the Errorlog
Q167331 FIX: Tape Backup May Cause Error 3201 Device Offline
Q166337 FIX: Auto-Start Stored Procedure w/ WAITFOR Causes 100% CPU Use
Q166298 FIX: #Deleted After Microsoft Access Sorts a SQL Server Table
Q166188 FIX: Server Stops/AV on Client Disconnect w/ an Open Transaction
Q165857 FIX: Delete/Rollback Can Cause AV on Table w/Text Col & Triggers
Q165756 FIX: A SELECT with a Large GROUP BY Clause May Return Error 614
Q165754 FIX: INT Divide by Zero Exception Error When Running a Query
Q165621 FIX: Error 231 After Opening a Server Side Cursor
Q165599 FIX: Datalength Function Returns 0 for NULL Text Columns
Q165597 FIX: Convert to Text Function w/NULL Input Returns Blank String
Q165596 FIX: HOLDLOCK on READTEXT Causes Error 7134
Q165579 FIX: DBCC NEWALLOC May Cause Incorrect Database Usage Count
Q165560 FIX: Existing Fill Factor Changed w/ Rebuild of Clustered Index
Q165559 FIX: Error 403 on Select w/ Nested Subqueries, Sums, and Groups
Q165558 FIX: AV on Cursor Declare Ssing Select on View w/ ORDER BY
Q165557 FIX: Thread AV in SP1 Using a Cursor Defined w/Constant and View
Q165513 FIX: Running a Global Temporary Stored Procedure May Cause AV
Q165512 FIX: Err 1203 Running Dynamic Cursor in a Stored Procedure
Q165511 FIX: A Derived Table Using a Group By May Cause Error 8158
Q165510 FIX: Numeric and Decimal Datatypes Do Not Always Use an Index
Q165389 FIX: Spid Missing with Trace Flag 4032 on RPC Events
Q165166 FIX: 'Load Tran' May Cause 806, 605, 2620, or 6902 with IRL on
Q165136 FIX: SQL 6.5 Does Not Allow Updates to a View If Grant Specified
Q165131 FIX: Stress of Lock Limit Threshold Causes Bufwait Error Message
Q165099 FIX: OrigFillFactor Reports Wrong Value for Non-Clustered Index
Q164997 FIX: Dump to Tape Fails Without Error in Errorlog
Q164972 FIX: Err 7134 w/ Text/Image Col. Update Using 'Where Current Of'
Q164734 FIX: Repetitive Connect/Disconnect May Shut Down SQL Server
Q164578 FIX: Error 1105 on Default Segment When Running DBCC DBREINDEX
Q164577 FIX: Error 803 on INSERT into Table with Multiple Indexes
Q164576 FIX: Error 2610 on Insert into Table with Multiple Indexes
Q164293 FIX: Correlated Subquery in Select List w/ ANSI JOIN Causes AV
Q164290 FIX: Srv_message_handler Text Limit
Q164287 FIX: Stored Procedure Can't Be Upgraded
Q164215 FIX: Bad Token or AV If Sp_cursoropen After Dropping Index
Q164178 FIX: Bcp_batch Stops Responding After Interleaved Bcp_sendrow
Q164056 FIX: Error 16934 If Sp_cursor Update on Sproc After Dump/Load
Q163908 FIX: Undetected Deadlock with Checkpoint and SELECT INTO
Q163730 FIX: AV Joining a Table with a Rowsize Over 1,962 Bytes
Q163452 FIX: Failed RPC Call from SQL Server Generates Error 18481
Q163128 FIX: Updates to Tables w/Text on SP2 Cols May Result in Errors
Q163047 FIX: Load and Recovery of a Read-Only Database May Cause AV
Q162906 FIX: AV If Extended Cursor Opens SP Without Execute Permission
Q161892 FIX: Error 8104 When DBO Tries to Run SET IDENTITY_INSERT ON
Q161741 FIX: Dump Aborts if PG_DMPTRLR Bit Set (MSG 3220)
Q161726 FIX: AV Selecting from VIEW with DISTINCT and Join
Q161645 FIX: Sp_Cursor Positioned Update Causes Access Violation
Q161599 FIX: Temporary Dump Devices May Be Created with the Wrong Name
Q161125 FIX: DUMP or LOAD with Tape May Fail on Windows NT 3.51
Q160584 FIX: Rollback in Single User Database Causes Msg 3307 and AV
Q159782 FIX: Concurrent CREATE TABLE & ALTER TABLE May Cause Deadlock
Q159744 FIX: Message 2 After Issuing ROLLBACK TRANSACTION Command
Q158684 FIX: Unable to Reload Master DB After Upgrading SQL Server
Q156265 FIX: Create Nonclustered Index Blocks Selects from Table
Q151573 FIX: Striped Dump to 7 or More Devices is Not Logged

SQL Enterprise Manager

Q135866 FIX: SEM - Edit Devices Dialog Displays Negative Device Size

Replication

Q164288 FIX: Replication Filter Stored Procedures Not Upgraded to 6.5

Additional query words: sp3 fix list bug ftp servpack patch database

Keywords : SSrvGen kbfix6.50.sp3
Version : winnt:6.5 Service Pack 3 and later
Platform : winnt
Issue type :