FIX: SQL Server 6.5 Service Pack 5a Fixlist

This article was previously published under Q197174

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

For additional information, see the following article or articles in the Microsoft Knowledge Base:


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

LIST OF PROBLEMS CORRECTED IN SERVICE PACK 5a

147830  (http://support.microsoft.com/kb/147830/EN-US/ ) FIX: Security Mgr w/ Long Group Names Can Cause SQL Shutdown
150458  (http://support.microsoft.com/kb/150458/EN-US/ ) FIX: Mirror Enabled After Losing Primary Device
151601  (http://support.microsoft.com/kb/151601/EN-US/ ) FIX: sp_OA Procedures Cause Memory Leak in SQLSERVR.EXE
152062  (http://support.microsoft.com/kb/152062/EN-US/ ) FIX: Query Times Out Too Early Under Multiprotocol Net-Library
154001  (http://support.microsoft.com/kb/154001/EN-US/ ) FIX: sproc Created but No Code in syscomments
155556  (http://support.microsoft.com/kb/155556/EN-US/ ) FIX: No Information Returned by xp_logininfo
155766  (http://support.microsoft.com/kb/155766/EN-US/ ) FIX: Perfmon Terminates While Monitoring SQL Procedure Cache
157804  (http://support.microsoft.com/kb/157804/EN-US/ ) FIX: Problem Using Xp_readerrorlog When Reading Large Errorlog
159042  (http://support.microsoft.com/kb/159042/EN-US/ ) FIX: DYNAMIC Cursor Fails to Release Sh_Page Lock

163082  (http://support.microsoft.com/kb/163082/EN-US/ ) FIX: Views Containing a UNION Resolve with Materializing Model
163152  (http://support.microsoft.com/kb/163152/EN-US/ ) FIX: Dump/Load May Fail to Work with Older Tape Drives and SCSI
164690  (http://support.microsoft.com/kb/164690/EN-US/ ) FIX: Insert/Update May Cause Client to Stop Responding
165510  (http://support.microsoft.com/kb/165510/EN-US/ ) FIX: Numeric and Decimal Datatypes Do Not Always Use an Index
166233  (http://support.microsoft.com/kb/166233/EN-US/ ) FIX: Unhandled Exception in SQL Server Using Keyset Cursors
166387  (http://support.microsoft.com/kb/166387/EN-US/ ) FIX: Striped Dumps May Cause Error 18001
166758  (http://support.microsoft.com/kb/166758/EN-US/ ) FIX: Dump File Handle Not Released After Error on Load Table
167603  (http://support.microsoft.com/kb/167603/EN-US/ ) FIX: LE Threshold Config. Values Do Not Take Effect Immediately
169492  (http://support.microsoft.com/kb/169492/EN-US/ ) FIX: Cannot Load a Table If the Owner Is Not SA or DBO
170295  (http://support.microsoft.com/kb/170295/EN-US/ ) FIX: Wrong Join Plan Selected That Causes Excessive Reads
170296  (http://support.microsoft.com/kb/170296/EN-US/ ) FIX: Deadlock on Table with Text/Image Column May Cause Errors
170507  (http://support.microsoft.com/kb/170507/EN-US/ ) FIX: READTEXT May Fail w/ Msg 7134 If Hard Coding Text Pointer
170616  (http://support.microsoft.com/kb/170616/EN-US/ ) FIX: Handled Exception Error Caused by Server Side Cursors
170803  (http://support.microsoft.com/kb/170803/EN-US/ ) FIX: Higher Cost Executing Query on View with Subquery
170994  (http://support.microsoft.com/kb/170994/EN-US/ ) FIX: Update View with Inner Join from Cursor Causes AV
171323  (http://support.microsoft.com/kb/171323/EN-US/ ) FIX: CmdExec May Cause Exception Violation on Scheduled Tasks
171867  (http://support.microsoft.com/kb/171867/EN-US/ ) FIX: Shared Intent Lock Acquired by READTEXT Are Not Released
172309  (http://support.microsoft.com/kb/172309/EN-US/ ) FIX: Infinite Loop When UPDATE of a Cursor with WHERE CURRENT OF
172571  (http://support.microsoft.com/kb/172571/EN-US/ ) FIX: AV Querying a View w/ CASE WHEN EXISTS and FORCEPLAN Is ON
173215  (http://support.microsoft.com/kb/173215/EN-US/ ) FIX: COMMIT TRAN Statement May Fail with Msg 602
173568  (http://support.microsoft.com/kb/173568/EN-US/ ) FIX: Managing Permissions Fails w/Err 21770 w/ User-Owned Tables
174483  (http://support.microsoft.com/kb/174483/EN-US/ ) FIX: Dumping to a DLT Tape Drive May Fail to Span Tapes
174484  (http://support.microsoft.com/kb/174484/EN-US/ ) FIX: Access Violation May Occur During a LOAD TRANSACTION
174853  (http://support.microsoft.com/kb/174853/EN-US/ ) FIX: Concurrent Xp_makewebtask May Cause an Access Violation
175126  (http://support.microsoft.com/kb/175126/EN-US/ ) FIX: Problems with Server Cursors on a Stored Procedure
175142  (http://support.microsoft.com/kb/175142/EN-US/ ) FIX: If ANSI_DEFAULTS On, Join Sequences in St. Procs Cause AV
175359  (http://support.microsoft.com/kb/175359/EN-US/ ) FIX: Force Index Option Fails with Temporary Tables in St. Procs
175789  (http://support.microsoft.com/kb/175789/EN-US/ ) FIX: Rebuilding Indexes w/ SQLMaint May Cause Incorrect Database
176092  (http://support.microsoft.com/kb/176092/EN-US/ ) FIX: Primary Key Violation Causes AV, Text Field Involved
176479  (http://support.microsoft.com/kb/176479/EN-US/ ) FIX: Double-Byte Character Set Insertion May Fail w/ Error 2627
176491  (http://support.microsoft.com/kb/176491/EN-US/ ) FIX: Err 1203 w/ SELECT ORDER BY DESC After an UPDATE in a Tran
176493  (http://support.microsoft.com/kb/176493/EN-US/ ) FIX: AV in Query w/Subselect on View w/JOIN and FORCEPLAN Is On
176684  (http://support.microsoft.com/kb/176684/EN-US/ ) FIX: Msdb..Syshistory Rows May Be Incorrectly Deleted
176999  (http://support.microsoft.com/kb/176999/EN-US/ ) FIX: DELETE Statement May Cause Server to Become Unresponsive
177114  (http://support.microsoft.com/kb/177114/EN-US/ ) FIX: Delete Using EXISTS & Subquery Doesn't Escalate Page Lock
178366  (http://support.microsoft.com/kb/178366/EN-US/ ) FIX: SELECT Into Variable with NO_BROWSETABLE Fails
178443  (http://support.microsoft.com/kb/178443/EN-US/ ) FIX: Regression Old Syntax Outer Join May Produce Error 613
178473  (http://support.microsoft.com/kb/178473/EN-US/ ) FIX: Concurrent Distribution Tasks May Cause an Unhandled Error
179222  (http://support.microsoft.com/kb/179222/EN-US/ ) FIX: UPDLOCK Locking Option Sets Only Shared Lock with sp_cursor
179283  (http://support.microsoft.com/kb/179283/EN-US/ ) FIX: Long Comment in .SQC File May Cause AV in Nsqlprep.exe
179924  (http://support.microsoft.com/kb/179924/EN-US/ ) FIX: 1203 If Attentions During Maintenance to Nonclustered Index
180101  (http://support.microsoft.com/kb/180101/EN-US/ ) FIX: INSERTs into Temp Tables w/Identity May Cause Deadlock
180102  (http://support.microsoft.com/kb/180102/EN-US/ ) FIX: SELECT INTO Temp Tables w/Identity Columns May Cause Errors
180603  (http://support.microsoft.com/kb/180603/EN-US/ ) FIX: Database Fallback May Cause Dbid to Change
180778  (http://support.microsoft.com/kb/180778/EN-US/ ) FIX: Xp_makewebtask Procedure May Cause Access Violation
181048  (http://support.microsoft.com/kb/181048/EN-US/ ) FIX: Queries Using Derived Tables or GROUP BY May Cause an AV
181244  (http://support.microsoft.com/kb/181244/EN-US/ ) FIX: INSERT..SELECT with Ignore_Dup_Row Clustered Index Stops
181514  (http://support.microsoft.com/kb/181514/EN-US/ ) FIX: Error 3307 with NOLOCK Joins in a Cursor Declaration
181557  (http://support.microsoft.com/kb/181557/EN-US/ ) FIX: Writelog Timeout When Replicating Cross-DB Transactions
181986  (http://support.microsoft.com/kb/181986/EN-US/ ) FIX: Access Violation on SELECT Statement with UNION ALL
184008  (http://support.microsoft.com/kb/184008/EN-US/ ) FIX: SQL Server Cluster Setup May Fail on Third-Party Disk Drive
184478  (http://support.microsoft.com/kb/184478/EN-US/ ) FIX: Repeated DBCC DBREINDEX Causes Stack Overflow Error
184494  (http://support.microsoft.com/kb/184494/EN-US/ ) FIX: INSERT..EXEC with RPC May Cause Access Violation, Msg 806
184882  (http://support.microsoft.com/kb/184882/EN-US/ ) FIX: Intstdist.sql Updates MSjob_commands Incorrectly
185806  (http://support.microsoft.com/kb/185806/EN-US/ ) FIX: SQL Server Service Stopped When IsAlive Fails to Connect
185964  (http://support.microsoft.com/kb/185964/EN-US/ ) FIX: Delete Where Current of Cursor Causes Server Instability
185965  (http://support.microsoft.com/kb/185965/EN-US/ ) FIX: Query Cancellation May Fail If No Delay After Query
186001  (http://support.microsoft.com/kb/186001/EN-US/ ) FIX: Duplicate Jobs Added to the MSjobs Tables
186916  (http://support.microsoft.com/kb/186916/EN-US/ ) FIX: Problems with Network Error During dbwritetext/dbmoretext
186979  (http://support.microsoft.com/kb/186979/EN-US/ ) FIX: Issuing KILL on Running SQL Web Task Stops SQL Server
187370  (http://support.microsoft.com/kb/187370/EN-US/ ) FIX: Large Number of Client Disconnects May Cause AV in ODS
187857  (http://support.microsoft.com/kb/187857/EN-US/ ) FIX: RPC Returns Error 7222 When Re-executed After Canceled RPC
187867  (http://support.microsoft.com/kb/187867/EN-US/ ) FIX: Pintable, NOLOCK, and JOIN Cause LRU/LazyWriter Errors
187867  (http://support.microsoft.com/kb/187867/EN-US/ ) FIX: Pintable, NOLOCK, and JOIN Cause LRU/LazyWriter Errors
188034  (http://support.microsoft.com/kb/188034/EN-US/ ) FIX: INSERT SELECT Statement Does Not Release Shared Intent Lock
188328  (http://support.microsoft.com/kb/188328/EN-US/ ) FIX: Access Violation Occurs with Some Cursors on Derived Table
189029  (http://support.microsoft.com/kb/189029/EN-US/ ) FIX: AV in Cursoropen() When Using 'WHERE CURRENT OF' and Cancel
189098  (http://support.microsoft.com/kb/189098/EN-US/ ) FIX: Shared Intent Locks Held After Validating Constraint
189343  (http://support.microsoft.com/kb/189343/EN-US/ ) FIX: ORDER BY Queries May Remove Spaces from ANSI_PADDING Tables
192829  (http://support.microsoft.com/kb/192829/EN-US/ ) FIX: Msg 267 and 202 on Stored Proc If Table Dropped/Re-created
192952  (http://support.microsoft.com/kb/192952/EN-US/ ) FIX: Database Dumps May Be Overwritable Despite Options
192953  (http://support.microsoft.com/kb/192953/EN-US/ ) FIX: Expired Dump Media Cannot Be Overwritten After 12/31/99
192955  (http://support.microsoft.com/kb/192955/EN-US/ ) FIX: Add New Task in Task Manager Does Not Allow Date 2/29/2000
192959  (http://support.microsoft.com/kb/192959/EN-US/ ) FIX: SQL Web Assistant: Cannot Schedule Page Creation After 1999
192962  (http://support.microsoft.com/kb/192962/EN-US/ ) FIX: Handled AV in SQL Server with Low Memory & Procedure Cache
192991  (http://support.microsoft.com/kb/192991/EN-US/ ) FIX: Correlated Subquery for a Large Table Causes Error 403
193043  (http://support.microsoft.com/kb/193043/EN-US/ ) FIX: Stored Procedure Creation Gets Garbled Entry in Syscomments
193392  (http://support.microsoft.com/kb/193392/EN-US/ ) FIX: Permissions Shown Incorrectly in SQL Enterprise Manager
193452  (http://support.microsoft.com/kb/193452/EN-US/ ) FIX: Insufficient Tempdb Space During Sort May Cause an AV
193454  (http://support.microsoft.com/kb/193454/EN-US/ ) FIX: Fetching from an Asynchronous Cursor May Cause a Hang
193757  (http://support.microsoft.com/kb/193757/EN-US/ ) FIX: Use of the RIGHT Function Within an ANSI Join Fails
193991  (http://support.microsoft.com/kb/193991/EN-US/ ) FIX: Transact-SQL READTEXT with INSERT EXEC Generates Error 611
193992  (http://support.microsoft.com/kb/193992/EN-US/ ) FIX: Attempt to Delete a Row May Raise Error 631
194216  (http://support.microsoft.com/kb/194216/EN-US/ ) FIX: Inserts into Table with IRL Turned On May Cause Error 826
194217  (http://support.microsoft.com/kb/194217/EN-US/ ) FIX: Access to TEXT Column of Temp Table Inside SP May Cause AV
194662  (http://support.microsoft.com/kb/194662/EN-US/ ) FIX: Concurrent Create/Drop of Stored Procedures May Cause 707
194664  (http://support.microsoft.com/kb/194664/EN-US/ ) FIX: Errors with Procedures Containing Aggregates and a HAVING Clause
194665  (http://support.microsoft.com/kb/194665/EN-US/ ) FIX: Incorrect Results from Sysprocesses with SQL 7 ODBC Driver
194666  (http://support.microsoft.com/kb/194666/EN-US/ ) FIX: Correlated Subquery and ISNULL May Cause Disconnect
195414  (http://support.microsoft.com/kb/195414/EN-US/ ) FIX: Deadlock Loop Causes Stack Overflow Unhandled Exception
195530  (http://support.microsoft.com/kb/195530/EN-US/ ) FIX: Heavy TEXT/IMAGE Inserts May Lead to Error 611
195539  (http://support.microsoft.com/kb/195539/EN-US/ ) FIX: Selecting TEXT/IMAGE with Insensitive Cursor May Disconnect
195542  (http://support.microsoft.com/kb/195542/EN-US/ ) FIX: Losing DTC Service May Leave Orphaned Transactions
195543  (http://support.microsoft.com/kb/195543/EN-US/ ) FIX: Attentions During Reformatting May Cause Error 1108 in Tempdb
197242  (http://support.microsoft.com/kb/197242/EN-US/ ) FIX: Logging Large Error Messages May Generate Access Violation
197563  (http://support.microsoft.com/kb/197563/EN-US/ ) FIX: Error Message Should Be Clearer When Multiple SELECTs in SP
197564  (http://support.microsoft.com/kb/197564/EN-US/ ) FIX: Carriage Return/Line Feed Not Written Correctly in Errorlog
198169  (http://support.microsoft.com/kb/198169/EN-US/ ) FIX: SQL Cluster: Error "Port 1433 in Use" on Alpha Platform
198170  (http://support.microsoft.com/kb/198170/EN-US/ ) FIX: SP4 Hotfix Performance Problem on Alpha Version
198653  (http://support.microsoft.com/kb/198653/EN-US/ ) FIX: An INSERT SELECT into a Table with IRL May Cause Error 818
198786  (http://support.microsoft.com/kb/198786/EN-US/ ) FIX: Cancelled Creation of Stored Procedure May Cause Error 707
199300  (http://support.microsoft.com/kb/199300/EN-US/ ) FIX: READTEXT After SELECT with HOLDLOCK Causes Error 1203
199763  (http://support.microsoft.com/kb/199763/EN-US/ ) FIX: Client Apps Stop Responding When Running Server-Side Cursors Against Stored Procedures
199791  (http://support.microsoft.com/kb/199791/EN-US/ ) FIX: Smalldatetime Conversion Error Stops Batch Jobs
199793  (http://support.microsoft.com/kb/199793/EN-US/ ) FIX: MSG 550 Occurs When Inserting into View 'WITH CHECK OPTION'
214415  (http://support.microsoft.com/kb/214415/EN-US/ ) FIX: ISQL Does Not Return Errors in Last Batch When Using -b Switch
214596  (http://support.microsoft.com/kb/214596/EN-US/ ) FIX: Alpha: Access Violations When Executing Query Plans the First Time
214650  (http://support.microsoft.com/kb/214650/EN-US/ ) FIX: SQL Server Error 613 Does Not Show Supplemental Message Information
215458  (http://support.microsoft.com/kb/215458/EN-US/ ) FIX: LOAD DATABASE Fails with Error 603
218149  (http://support.microsoft.com/kb/218149/EN-US/ ) FIX: Replication Log Reader Task Causes Memory Leak