FIX: SQL Server 6.5 Service Pack 5a Fixlist

ID: Q197174

The information in this article applies to:
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, please see the following article(s) in the Microsoft Knowledge Base:
Q197177 INF: How to Obtain SQL Server 6.5 Service Pack 5a


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

LIST OF PROBLEMS CORRECTED IN SERVICE PACK 5a



Q147830 FIX: Security Mgr w/ Long Group Names Can Cause SQL Shutdown
Q150458 FIX: Mirror Enabled After Losing Primary Device
Q151601 FIX: sp_OA Procedures Cause Memory Leak in SQLSERVR.EXE
Q152062 FIX: Query Times Out Too Early Under Multiprotocol Net-Library
Q154001 FIX: sproc Created but No Code in syscomments
Q155556 FIX: No Information Returned by xp_logininfo
Q155766 FIX: Perfmon Terminates While Monitoring SQL Procedure Cache
Q157804 FIX: Problem Using Xp_readerrorlog When Reading Large Errorlog
Q159042 FIX: DYNAMIC Cursor Fails to Release Sh_Page Lock
Q159221 FIX: Xp_cmdshell Run by Non-SA Causes Error 1326
Q163069 FIX: Multiplying Numeric Datatypes May Yield Lower Precision
Q163082 FIX: Views Containing a UNION Resolve with Materializing Model
Q163152 FIX: Dump/Load May Fail to Work with Older Tape Drives and SCSI
Q164690 FIX: Insert/Update May Cause Client to Stop Responding
Q165510 FIX: Numeric and Decimal Datatypes Do Not Always Use an Index
Q166233 FIX: Unhandled Exception in SQL Server Using Keyset Cursors
Q166387 FIX: Striped Dumps May Cause Error 18001
Q166758 FIX: Dump File Handle Not Released After Error on Load Table
Q167603 FIX: LE Threshold Config. Values Do Not Take Effect Immediately
Q169492 FIX: Cannot Load a Table If the Owner Is Not SA or DBO
Q170295 FIX: Wrong Join Plan Selected That Causes Excessive Reads
Q170296 FIX: Deadlock on Table with Text/Image Column May Cause Errors
Q170507 FIX: READTEXT May Fail w/ Msg 7134 If Hard Coding Text Pointer
Q170616 FIX: Handled Exception Error Caused by Server Side Cursors
Q170803 FIX: Higher Cost Executing Query on View with Subquery
Q170994 FIX: Update View with Inner Join from Cursor Causes AV
Q171323 FIX: CmdExec May Cause Exception Violation on Scheduled Tasks
Q171867 FIX: Shared Intent Lock Acquired by READTEXT Are Not Released
Q172309 FIX: Infinite Loop When UPDATE of a Cursor with WHERE CURRENT OF
Q172571 FIX: AV Querying a View w/ CASE WHEN EXISTS and FORCEPLAN Is ON
Q173215 FIX: COMMIT TRAN Statement May Fail with Msg 602
Q173568 FIX: Managing Permissions Fails w/Err 21770 w/ User-Owned Tables
Q174483 FIX: Dumping to a DLT Tape Drive May Fail to Span Tapes
Q174484 FIX: Access Violation May Occur During a LOAD TRANSACTION
Q174853 FIX: Concurrent Xp_makewebtask May Cause an Access Violation
Q175126 FIX: Problems with Server Cursors on a Stored Procedure
Q175142 FIX: If ANSI_DEFAULTS On, Join Sequences in St. Procs Cause AV
Q175359 FIX: Force Index Option Fails with Temporary Tables in St. Procs
Q175789 FIX: Rebuilding Indexes w/ SQLMaint May Cause Incorrect Database
Q176092 FIX: Primary Key Violation Causes AV, Text Field Involved
Q176479 FIX: Double-Byte Character Set Insertion May Fail w/ Error 2627
Q176491 FIX: Err 1203 w/ SELECT ORDER BY DESC After an UPDATE in a Tran
Q176493 FIX: AV in Query w/Subselect on View w/JOIN and FORCEPLAN Is On
Q176684 FIX: Msdb..Syshistory Rows May Be Incorrectly Deleted
Q176999 FIX: DELETE Statement May Cause Server to Become Unresponsive
Q177114 FIX: Delete Using EXISTS & Subquery Doesn't Escalate Page Lock
Q178366 FIX: SELECT Into Variable with NO_BROWSETABLE Fails
Q178443 FIX: Regression Old Syntax Outer Join May Produce Error 613
Q178473 FIX: Concurrent Distribution Tasks May Cause an Unhandled Error
Q179222 FIX: UPDLOCK Locking Option Sets Only Shared Lock with sp_cursor
Q179283 FIX: Long Comment in .SQC File May Cause AV in Nsqlprep.exe
Q179924 FIX: 1203 If Attentions During Maintenance to Nonclustered Index
Q180101 FIX: INSERTs into Temp Tables w/Identity May Cause Deadlock
Q180102 FIX: SELECT INTO Temp Tables w/Identity Columns May Cause Errors
Q180603 FIX: Database Fallback May Cause Dbid to Change
Q180778 FIX: Xp_makewebtask Procedure May Cause Access Violation
Q181048 FIX: Queries Using Derived Tables or GROUP BY May Cause an AV
Q181244 FIX: INSERT..SELECT with Ignore_Dup_Row Clustered Index Stops
Q181514 FIX: Error 3307 with NOLOCK Joins in a Cursor Declaration
Q181557 FIX: Writelog Timeout When Replicating Cross-DB Transactions
Q181986 FIX: Access Violation on SELECT Statement with UNION ALL
Q184008 FIX: SQL Server Cluster Setup May Fail on Third-Party Disk Drive
Q184478 FIX: Repeated DBCC DBREINDEX Causes Stack Overflow Error
Q184494 FIX: INSERT..EXEC with RPC May Cause Access Violation, Msg 806
Q184882 FIX: Intstdist.sql Updates MSjob_commands Incorrectly
Q185806 FIX: SQL Server Service Stopped When IsAlive Fails to Connect
Q185964 FIX: Delete Where Current of Cursor Causes Server Instability
Q185965 FIX: Query Cancellation May Fail If No Delay After Query
Q186001 FIX: Duplicate Jobs Added to the MSjobs Tables
Q186916 FIX: Problems with Network Error During dbwritetext/dbmoretext
Q186979 FIX: Issuing KILL on Running SQL Web Task Stops SQL Server
Q187370 FIX: Large Number of Client Disconnects May Cause AV in ODS
Q187857 FIX: RPC Returns Error 7222 When Re-executed After Canceled RPC
Q187867 FIX: Pintable, NOLOCK, and JOIN Cause LRU/LazyWriter Errors
Q187867 FIX: Pintable, NOLOCK, and JOIN Cause LRU/LazyWriter Errors
Q188034 FIX: INSERT SELECT Statement Does Not Release Shared Intent Lock
Q188328 FIX: Access Violation Occurs with Some Cursors on Derived Table
Q189029 FIX: AV in Cursoropen() When Using 'WHERE CURRENT OF' and Cancel
Q189098 FIX: Shared Intent Locks Held After Validating Constraint
Q189343 FIX: ORDER BY Queries May Remove Spaces from ANSI_PADDING Tables
Q192829 FIX: Msg 267 and 202 on Stored Proc If Table Dropped/Re-created
Q192952 FIX: Database Dumps May Be Overwritable Despite Options
Q192953 FIX: Expired Dump Media Cannot Be Overwritten After 12/31/99
Q192955 FIX: Add New Task in Task Manager Does Not Allow Date 2/29/2000
Q192959 FIX: SQL Web Assistant: Cannot Schedule Page Creation After 1999
Q192962 FIX: Handled AV in SQL Server with Low Memory & Procedure Cache
Q192991 FIX: Correlated Subquery for a Large Table Causes Error 403
Q193043 FIX: Stored Procedure Creation Gets Garbled Entry in Syscomments
Q193392 FIX: Permissions Shown Incorrectly in SQL Enterprise Manager
Q193452 FIX: Insufficient Tempdb Space During Sort May Cause an AV
Q193454 FIX: Fetching from an Asynchronous Cursor May Cause a Hang
Q193757 FIX: Use of the RIGHT Function Within an ANSI Join Fails
Q193991 FIX: Transact-SQL READTEXT with INSERT EXEC Generates Error 611
Q193992 FIX: Attempt to Delete a Row May Raise Error 631
Q194216 FIX: Inserts into Table with IRL Turned On May Cause Error 826
Q194217 FIX: Access to TEXT Column of Temp Table Inside SP May Cause AV
Q194662 FIX: Concurrent Create/Drop of Stored Procedures May Cause 707
Q194664 FIX: Errors with Procedures Containing Aggregates and a HAVING Clause
Q194665 FIX: Incorrect Results from Sysprocesses with SQL 7 ODBC Driver
Q194666 FIX: Correlated Subquery and ISNULL May Cause Disconnect
Q195414 FIX: Deadlock Loop Causes Stack Overflow Unhandled Exception
Q195529 FIX: Cursor with UPDLOCK Hint May Leave Object in Open State
Q195530 FIX: Heavy TEXT/IMAGE Inserts May Lead to Error 611
Q195539 FIX: Selecting TEXT/IMAGE with Insensitive Cursor May Disconnect
Q195542 FIX: Losing DTC Service May Leave Orphaned Transactions
Q195543 FIX: Attentions During Reformatting May Cause Error 1108 in Tempdb
Q197242 FIX: Logging Large Error Messages May Generate Access Violation
Q197563 FIX: Error Message Should Be Clearer When Multiple SELECTs in SP
Q197564 FIX: Carriage Return/Line Feed Not Written Correctly in Errorlog
Q198169 FIX: SQL Cluster: Error "Port 1433 in Use" on Alpha Platform
Q198170 FIX: SP4 Hotfix Performance Problem on Alpha Version
Q198653 FIX: An INSERT SELECT into a Table with IRL May Cause Error 818
Q198786 FIX: Cancelled Creation of Stored Procedure May Cause Error 707
Q199300 FIX: READTEXT After SELECT with HOLDLOCK Causes Error 1203
Q199791 FIX: Smalldatetime Conversion Error Stops Batch Jobs
Q199793 FIX: MSG 550 Occurs When Inserting into View 'WITH CHECK OPTION'
Q214415 FIX: ISQL Does Not Return Errors in Last Batch When Using -b Switch
Q214596 FIX: Alpha: Access Violations When Executing Query Plans the First Time
Q214650 FIX: SQL Server Error 613 Does Not Show Supplemental Message Information
Q215458 FIX: LOAD DATABASE Fails with Error 603
Q218149 FIX: Replication Log Reader Task Causes Memory Leak

Additional query words: prodsql sp sp5 sp5a 


Keywords          : SSrvGen 
Version           : winnt:6.5 Service Pack 5a
Platform          : winnt 
Issue type        : kbinfo

Last Reviewed: July 19, 1999