FIX: SQL Server 6.5 Service Pack 3 Fixlist

• Microsoft SQL Server, version 6.5 Service Pack 3

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 3, which is now available from your primary support provider. 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.

LIST OF PROBLEMS CORRECTED IN SERVICE PACK 3

ODBC

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

SERVER

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
Q158464  FIX: Sp_columns Returns More Than One Row for a Column
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