Microsoft SQL Server 6.5 Service Pack 5 Fixlist

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 the most up to date information about fixes in this service pack, please see the following article in the Microsoft Knowledge Base:

ARTICLE-ID: Q197174
TITLE : FIX: SQL Server 6.5 Service Pack 5 Fixlist

• FIX: Security Mgr w/ Long Group Names Can Cause SQL Shutdown (Q147830)
• FIX: Mirror Enabled After Losing Primary Device (Q150458)
• FIX: Query Times Out Too Early Under Multiprotocol Net-Library (Q152062)
• FIX: sproc Created but No Code in syscomments (Q154001)
• FIX: No Information Returned by xp_logininfo (Q155556)
• FIX: Perfmon Terminates While Monitoring SQL Procedure Cache (Q155766)
• FIX: Problem Using Xp_readerrorlog When Reading Large Errorlog (Q157804)
• FIX: DYNAMIC Cursor Fails to Release Sh_Page Lock (Q159042)
• FIX: Xp_cmdshell Run by Non-SA Causes Error 1326 (Q159221)
• FIX: Multiplying Numeric Datatypes May Yield Lower Precision (Q163069)
• FIX: Views Containing a UNION Resolve with Materializing Model (Q163082)
• FIX: Dump/Load May Fail to Work with Older Tape Drives and SCSI (Q163152)
• FIX: Insert/Update May Cause Client to Stop Responding (Q164690)
• FIX: Unhandled Exception in SQL Server Using Keyset Cursors (Q166233)
• FIX: Striped Dumps May Cause Error 18001 (Q166387)
• FIX: Dump File Handle Not Released After Error on Load Table (Q166758)
• FIX: LE Threshold Config. Values Do Not Take Effect Immediately (Q167603)
• FIX: Cannot Load a Table If the Owner Is Not SA or DBO (Q169492)
• FIX: Wrong Join Plan Selected That Causes Excessive Reads (Q170295)
• FIX: Deadlock on Table with Text/Image Column May Cause Errors (Q170296)
• FIX: Handled Exception Error Caused by Server Side Cursors (Q170616)
• FIX: Higher Cost Executing Query on View with Subquery (Q170803)
• FIX: Update View with Inner Join from Cursor Causes AV (Q170994)
• FIX: CmdExec May Cause Exception Violation on Scheduled Tasks (Q171323)
• FIX: Shared Intent Lock Acquired by READTEXT Are Not Released (Q171867)
• FIX: Infinite Loop When UPDATE of a Cursor with WHERE CURRENT OF (Q172309)
• FIX: AV Querying a View w/ CASE WHEN EXISTS and FORCEPLAN Is ON (Q172571)
• FIX: Managing Permissions Fails w/Err 21770 w/ User-Owned Tables (Q173568)
• FIX: Dumping to a DLT Tape Drive May Fail to Span Tapes (Q174483)
• FIX: Concurrent Xp_makewebtask May Cause an Access Violation (Q174853)
• FIX: Problems with Server Cursors on a Stored Procedure (Q175126)
• FIX: If ANSI_DEFAULTS On, Join Sequences in St. Procs Cause AV (Q175142)
• FIX: Force Index Option Fails with Temporary Tables in St. Procs (Q175359)
• FIX: Rebuilding Indexes w/ SQLMaint May Cause Incorrect Database (Q175789)
• FIX: Primary Key Violation Causes AV, Text Field Involved (Q176092)
• FIX: Double-Byte Character Set Insertion May Fail w/ Error 2627 (Q176479)
• FIX: Err 1203 w/ SELECT ORDER BY DESC After an UPDATE in a Tran (Q176491)
• FIX: Msdb..Syshistory Rows May Be Incorrectly Deleted (Q176684)
• FIX: DELETE Statement May Cause Server to Become Unresponsive (Q176999)
• FIX: Delete Using EXISTS & Subquery Doesn't Escalate Page Lock (Q177114)
• FIX: SELECT Into Variable with NO_BROWSETABLE Fails (Q178366)
• FIX: Regression Old Syntax Outer Join May Produce Error 613 (Q178443)
• FIX: Concurrent Distribution Tasks May Cause an Unhandled Error (Q178473)
• FIX: UPDLOCK Locking Option Sets Only Shared Lock with sp_cursor (Q179222)
• FIX: Long Comment in .SQC File May Cause AV in Nsqlprep.exe (Q179283)
• FIX: 1203 If Attentions During Maintenance to Nonclustered Index (Q179924)
• FIX: INSERTs into Temp Tables w/Identity May Cause Deadlock (Q180101)
• FIX: SELECT INTO Temp Tables w/Identity Columns May Cause Errors (Q180102)
• FIX: Database Fallback May Cause Dbid to Change (Q180603)
• FIX: Xp_makewebtask Procedure May Cause Access Violation (Q180778)
• FIX: Queries Using Derived Tables or GROUP BY May Cause an AV (Q181048)
• FIX: INSERT..SELECT with Ignore_Dup_Row Clustered Index Stops (Q181244)
• FIX: Writelog Timeout When Replicating Cross-DB Transactions (Q181557)
• FIX: SQL Server Cluster Setup May Fail on Third-Party Disk Drive (Q184008)
• FIX: Repeated DBCC DBREINDEX Causes Stack Overflow Error (Q184478)
• FIX: INSERT..EXEC with RPC May Cause Access Violation, Msg 806 (Q184494)
• FIX: Intstdist.sql Updates MSjob_commands Incorrectly (Q184882)
• FIX: SQL Server Service Stopped When IsAlive Fails to Connect (Q185806)
• FIX: Delete Where Current of Cursor Causes Server Instability (Q185964)
• FIX: Query Cancellation May Fail If No Delay After Query (Q185965)
• FIX: Duplicate Jobs Added to the MSjobs Tables (Q186001)
• FIX: Problems with Network Error During dbwritetext/dbmoretext (Q186916)
• FIX: Large Query Text from Socket Client May Cause ODS AV (Q187278)
• FIX: Large Number of Client Disconnects May Cause AV in ODS (Q187370)
• FIX: RPC Returns Error 7222 When Re-executed After Canceled RPC (Q187857)
• FIX: INSERT SELECT Statement Does Not Release Shared Intent Lock (Q188034)
• FIX: AV in Cursoropen() When Using 'WHERE CURRENT OF' and Cancel (Q189029)
• FIX: Shared Intent Locks Held After Validating Constraint (Q189098)
• FIX: ORDER BY Queries May Remove Spaces from ANSI_PADDING Tables (Q189343)
• FIX: Msg 267 and 202 on Stored Proc If Table Dropped/Re-created (Q192829)
• FIX: Database Dumps May Be Overwritable Despite Options (Q192952)
• FIX: Expired Dump Media Cannot Be Overwritten After 12/31/99 (Q192953)
• FIX: Add New Task in Task Manager Does Not Allow Date 2/29/2000 (Q192955)
• FIX: Some Task Management St. Procs. Accept Some Invalid Dates (Q192958)
• FIX: SQL Web Assistant: Cannot Schedule Page Creation After 1999 (Q192959)
• FIX: Handled AV in SQL Server with Low Memory & Procedure Cache (Q192962)
• FIX: Correlated Subquery for a Large Table Causes Error 403 (Q192991)
• FIX: Stored Procedure Creation Gets Garbled Entry in Syscomments (Q193043)
• FIX: Permissions Shown Incorrectly in SQL Enterprise Manager (Q193392)
• FIX: Insufficient Tempdb Space During Sort May Cause an AV (Q193452)
• FIX: Fetching from an Asynchronous Cursor May Cause a Hang (Q193454)
• FIX: Use of the RIGHT Function Within an ANSI Join Fails (Q193757)
• FIX: Transact-SQL READTEXT with INSERT EXEC Generates Error 611 (Q193991)
• FIX: Attempt to Delete a Row May Raise Error 631 (Q193992)
• FIX: Inserts into Table with IRL Turned On May Cause Error 826 (Q194216)
• FIX: Access to TEXT Column of Temp Table Inside SP May Cause AV (Q194217)
• FIX: Concurrent Create/Drop of Stored Procedures May Cause 707 (Q194662)
• FIX: Correlated Subquery and ISNULL May Cause Disconnect (Q194666)
• FIX: Cursor with UPDLOCK Hint May Leave Object in Open State (Q195529)
• FIX: Heavy TEXT/IMAGE Inserts May Lead to Error 611 (Q195530)
• FIX: Losing DTC Service May Leave Orphaned Transactions (Q195542)
• FIX: Logging Large Error Messages May Generate Access Violation (Q197242)