Article ID: 274035 - View products that this article applies to.
This article was previously published under Q274035
This article has been archived. It is offered "as is" and will no longer be updated.
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:
The following table illustrates the correspondence between the version string reported by @@VERSION for each of the SQL Server 6.5 service packs:
Collapse this tableExpand this table
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.
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
(http://support.microsoft.com/kb/199122/ )FIX: Regr:INSERT-EXEC rpc generates 3307 on constraint violation
(http://support.microsoft.com/kb/214858/ )FIX: SELECT INTO including UNION with trace flag 5302 causes access violation
(http://support.microsoft.com/kb/216700/ )FIX: "IF UPDATE" functionality does not work in SQL Server 6.5 Service Pack 5 and 5a
(http://support.microsoft.com/kb/217102/ )FIX: Selecting text or image field using table owner's name causes error
(http://support.microsoft.com/kb/218834/ )FIX: Select with ANSI joins against view with Union operator and ANSI joins fails with error 4409
(http://support.microsoft.com/kb/219051/ )FIX: Access violation on stored procedure inserting or updating table with rules
(http://support.microsoft.com/kb/219060/ )FIX: ROLLUP and CUBE return incorrect summary values if column has CASE expression
(http://support.microsoft.com/kb/220154/ )FIX: Forward only and dynamic cursors may infinitely loop
(http://support.microsoft.com/kb/221176/ )FIX: Sp_cursoropen causes AV on the initial execution after LOAD
(http://support.microsoft.com/kb/223169/ )FIX: Local connections are delayed up to 12 seconds after you run DBCC Checkdb command several times
(http://support.microsoft.com/kb/225143/ )FIX: Implicit conversion with aggregate functions causes overflow
(http://support.microsoft.com/kb/226125/ )FIX: 3600 errors written to ERRORLOG With INSERT..EXEC of xproc
(http://support.microsoft.com/kb/230044/ )FIX: SELECT INTO with TEXT/IMAGE data is not a non-logged operation
(http://support.microsoft.com/kb/231323/ )FIX: SP5a regression: Access violations with tempdb deadlocking, attentions
(http://support.microsoft.com/kb/233258/ )FIX: DBCC DBREINDEX may cause a LOAD TRAN to fail with error 1511
(http://support.microsoft.com/kb/233259/ )FIX: Error 3307 after canceling large UPDATE statement
(http://support.microsoft.com/kb/234783/ )FIX: Error 8115 on conversion from NUMERIC constant to REAL
(http://support.microsoft.com/kb/235220/ )FIX: Enlisting multiple connections in the same DTC transaction context can cause SPID stop responding
(http://support.microsoft.com/kb/237686/ )FIX: Deferred updates, triggers, and READ UNCOMMITTED may leak memory
(http://support.microsoft.com/kb/240888/ )FIX: ANSI_PADDING ignores using subquery in Insert
(http://support.microsoft.com/kb/241304/ )FIX: Error 1203 occurs when trigger fires on insert to table with foreign key constraint
(http://support.microsoft.com/kb/243050/ )FIX: Error 1203 occurs with trace flag 5302
(http://support.microsoft.com/kb/244505/ )FIX: Query with multiple aggregate functions and subqueries may encounter AV
(http://support.microsoft.com/kb/245552/ )FIX: SH_PAGE lock not released after fetch operation on keyset cursor
(http://support.microsoft.com/kb/245807/ )FIX: Server unresponsive after deadlocks under tempdb stress
(http://support.microsoft.com/kb/248483/ )FIX: Client disconnects can cause SQL Server instability when using more than two gigabytes of memory
(http://support.microsoft.com/kb/248764/ )FIX: DBCC TEXTALLOC may cause SQL Server to stop responding
(http://support.microsoft.com/kb/251333/ )FIX: Dump database logs flush_cache errors and does not complete
(http://support.microsoft.com/kb/253927/ )FIX: SP5a regression- Trace flag 1204 causes access violation and server becomes unresponsive
(http://support.microsoft.com/kb/258084/ )FIX: SPID may stop responding with CPU spin during log out when it drops temp procedure
(http://support.microsoft.com/kb/263661/ )FIX: Users may unexpectedly encounter FLT_UNDERFLOW_EXCEPTION errors
(http://support.microsoft.com/kb/265838/ )FIX: Attention events that occur during blocking may cause SQL Server to stop responding, cause AVs or other errors
(http://support.microsoft.com/kb/271835/ )FIX: SPID may stop responding with status of SPINLOOP during a rollback operation
(http://support.microsoft.com/kb/271841/ )FIX: Cursor fetches duplicate row after positioned update
(http://support.microsoft.com/kb/271848/ )FIX: Selection of a text column from keyset cursor defined as join might cause access violation
(http://support.microsoft.com/kb/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:
197174To download the Post Service Pack 5a Update, see the following article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/197174/ )FIX: SQL Server 6.5 Service Pack 5a fixlist
274036To view the Readme.txt file that accompanies the Post Service Pack 5a Update, see the following article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/274036/ )Readme.txt for SQL Server 6.5 Post Service Pack 5a Update
(http://support.microsoft.com/kb/273914/ )How to obtain SQL Server 6.5 Post Service Pack 5a Update
Contact us for more help
Connect with Answer Desk for expert help.