Article ID: 274035
Article Last Modified on 11/30/2004
APPLIES TO
- Microsoft SQL Server 6.5 Standard Edition
This article was previously published under Q274035
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
Additional query words: sp sp5a
Keywords: kbinfo KB274035
