SQL Server 6.5 Post Service Pack 5a Update fixlist (274035)

SUMMARY

The "More Information" section of this article contains a list of fixes that are included in the SQL Server 6.5 Post Service Pack 5a Update. These are fixes for problems that were discovered in SQL Server 6.5 Service Pack 5a after it was released. If you are running SQL Server 6.5 Service Pack 5 or 5a, Microsoft recommends that you apply this update to your system only if your configuration is affected by problems that are fixed by this update. For more information, contact your primary support provider.

To determine which SQL Server service pack is currently running on your computer, execute the following statement from either ISQL or ISQL/w:

SELECT @@version

The following table illustrates the correspondence between the version string reported by @@VERSION for each of the SQL Server 6.5 service packs:

SELECT @@VERSION number	Description
6.50.201	Original SQL Server 6.5 release
6.50.213	SQL Server 6.5 with Service Pack 1
6.50.240	SQL Server 6.5 with Service Pack 2
6.50.258	SQL Server 6.5 with Service Pack 3
6.50.281	SQL Server 6.5 with Service Pack 4
6.50.415	SQL Server 6.5 with Service Pack 5
6.50.416	SQL Server 6.5 with Service Pack 5a
6.50.479	Post Service Pack 5 Update

NOTE: Only apply the Post Service Pack 5 Update if the version of your existing service pack is between 6.50.415 and 6.50.479. If you have a version earlier than 6.50.415, you must first apply Service Pack 5a, and then apply the Post Service Pack 5 Update. If you have version 6.50.479 or later installed, you cannot apply the Post-Service Pack 5 Update.

MORE INFORMATION

For information about each corrected problem in the Post Service Pack 5a Update for Microsoft SQL Server 6.5 (build 6.50.479), click the link or use the Qxxxxxx number in the following table to query for the article in the Microsoft Knowledge Base.

Note that the 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.

SQL Server 6.5 Post Service Pack 5a Update Fixlist

199122 FIX: Regr:INSERT-EXEC rpc generates 3307 on constraint violation

214858 FIX: SELECT INTO including UNION with trace flag 5302 causes access violation

216700 FIX: "IF UPDATE" functionality does not work in SQL Server 6.5 Service Pack 5 and 5a

217102 FIX: Selecting text or image field using table owner's name causes error

218834 FIX: Select with ANSI joins against view with Union operator and ANSI joins fails with error 4409

219051 FIX: Access violation on stored procedure inserting or updating table with rules

219060 FIX: ROLLUP and CUBE return incorrect summary values if column has CASE expression

220154 FIX: Forward only and dynamic cursors may infinitely loop

221176 FIX: Sp_cursoropen causes AV on the initial execution after LOAD

223169 FIX: Local connections are delayed up to 12 seconds after you run DBCC Checkdb command several times

225143 FIX: Implicit conversion with aggregate functions causes overflow

226125 FIX: 3600 errors written to ERRORLOG With INSERT..EXEC of xproc

230044 FIX: SELECT INTO with TEXT/IMAGE data is not a non-logged operation

231323 FIX: SP5a regression: Access violations with tempdb deadlocking, attentions

233258 FIX: DBCC DBREINDEX may cause a LOAD TRAN to fail with error 1511

233259 FIX: Error 3307 after canceling large UPDATE statement

234783 FIX: Error 8115 on conversion from NUMERIC constant to REAL

235220 FIX: Enlisting multiple connections in the same DTC transaction context can cause SPID stop responding

237686 FIX: Deferred updates, triggers, and READ UNCOMMITTED may leak memory

240888 FIX: ANSI_PADDING ignores using subquery in Insert

241304 FIX: Error 1203 occurs when trigger fires on insert to table with foreign key constraint

243050 FIX: Error 1203 occurs with trace flag 5302

244505 FIX: Query with multiple aggregate functions and subqueries may encounter AV

245552 FIX: SH_PAGE lock not released after fetch operation on keyset cursor

245807 FIX: Server unresponsive after deadlocks under tempdb stress

248483 FIX: Client disconnects can cause SQL Server instability when using more than two gigabytes of memory

248764 FIX: DBCC TEXTALLOC may cause SQL Server to stop responding

251333 FIX: Dump database logs flush_cache errors and does not complete

253927 FIX: SP5a regression- Trace flag 1204 causes access violation and server becomes unresponsive

258084 FIX: SPID may stop responding with CPU spin during log out when it drops temp procedure

263661 FIX: Users may unexpectedly encounter FLT_UNDERFLOW_EXCEPTION errors

265838 FIX: Attention events that occur during blocking may cause SQL Server to stop responding, cause AVs or other errors

271835 FIX: SPID may stop responding with status of SPINLOOP during a rollback operation

271841 FIX: Cursor fetches duplicate row after positioned update

271848 FIX: Selection of a text column from keyset cursor defined as join might cause access violation

272426 FIX: Error message 1203 followed by stack overflow With keyset cursors

If you have not already done so, you must install SQL Server 6.5 Service Pack 5a before installing the SQL Server 6.5 Post Service Pack 5a Update. SQL Server service packs are cumulative. All of the problems corrected by earlier service packs are also corrected by SQL Server 6.5 Service Pack 5a. For a list of those problems in Service Pack 5a, refer to the following article in the Microsoft Knowledge Base:

197174 FIX: SQL Server 6.5 Service Pack 5a fixlist

To download the Post Service Pack 5a Update, see the following article in the Microsoft Knowledge Base:

274036 Readme.txt for SQL Server 6.5 Post Service Pack 5a Update

To view the Readme.txt file that accompanies the Post Service Pack 5a Update, see the following article in the Microsoft Knowledge Base:

273914 How to obtain SQL Server 6.5 Post Service Pack 5a Update