DetailPage-MSS-KB

Microsoft small business knowledge base

Article ID: 274035 - Last Review: November 2, 2013 - Revision: 6.0

This article was previously published under Q274035
This article has been archived. It is offered "as is" and will no longer be updated.

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:

Collapse this tableExpand this table
SELECT @@VERSION numberDescription
6.50.201Original SQL Server 6.5 release
6.50.213SQL Server 6.5 with Service Pack 1
6.50.240SQL Server 6.5 with Service Pack 2
6.50.258SQL Server 6.5 with Service Pack 3
6.50.281SQL Server 6.5 with Service Pack 4
6.50.415SQL Server 6.5 with Service Pack 5
6.50.416SQL Server 6.5 with Service Pack 5a
6.50.479Post 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  (http://support.microsoft.com/kb/199122/ ) FIX: Regr:INSERT-EXEC rpc generates 3307 on constraint violation
214858  (http://support.microsoft.com/kb/214858/ ) FIX: SELECT INTO including UNION with trace flag 5302 causes access violation
216700  (http://support.microsoft.com/kb/216700/ ) FIX: "IF UPDATE" functionality does not work in SQL Server 6.5 Service Pack 5 and 5a
217102  (http://support.microsoft.com/kb/217102/ ) FIX: Selecting text or image field using table owner's name causes error
218834  (http://support.microsoft.com/kb/218834/ ) FIX: Select with ANSI joins against view with Union operator and ANSI joins fails with error 4409
219051  (http://support.microsoft.com/kb/219051/ ) FIX: Access violation on stored procedure inserting or updating table with rules
219060  (http://support.microsoft.com/kb/219060/ ) FIX: ROLLUP and CUBE return incorrect summary values if column has CASE expression
220154  (http://support.microsoft.com/kb/220154/ ) FIX: Forward only and dynamic cursors may infinitely loop
221176  (http://support.microsoft.com/kb/221176/ ) FIX: Sp_cursoropen causes AV on the initial execution after LOAD
223169  (http://support.microsoft.com/kb/223169/ ) FIX: Local connections are delayed up to 12 seconds after you run DBCC Checkdb command several times
225143  (http://support.microsoft.com/kb/225143/ ) FIX: Implicit conversion with aggregate functions causes overflow
226125  (http://support.microsoft.com/kb/226125/ ) FIX: 3600 errors written to ERRORLOG With INSERT..EXEC of xproc
230044  (http://support.microsoft.com/kb/230044/ ) FIX: SELECT INTO with TEXT/IMAGE data is not a non-logged operation
231323  (http://support.microsoft.com/kb/231323/ ) FIX: SP5a regression: Access violations with tempdb deadlocking, attentions
233258  (http://support.microsoft.com/kb/233258/ ) FIX: DBCC DBREINDEX may cause a LOAD TRAN to fail with error 1511
233259  (http://support.microsoft.com/kb/233259/ ) FIX: Error 3307 after canceling large UPDATE statement
234783  (http://support.microsoft.com/kb/234783/ ) FIX: Error 8115 on conversion from NUMERIC constant to REAL
235220  (http://support.microsoft.com/kb/235220/ ) FIX: Enlisting multiple connections in the same DTC transaction context can cause SPID stop responding
237686  (http://support.microsoft.com/kb/237686/ ) FIX: Deferred updates, triggers, and READ UNCOMMITTED may leak memory
240888  (http://support.microsoft.com/kb/240888/ ) FIX: ANSI_PADDING ignores using subquery in Insert
241304  (http://support.microsoft.com/kb/241304/ ) FIX: Error 1203 occurs when trigger fires on insert to table with foreign key constraint
243050  (http://support.microsoft.com/kb/243050/ ) FIX: Error 1203 occurs with trace flag 5302
244505  (http://support.microsoft.com/kb/244505/ ) FIX: Query with multiple aggregate functions and subqueries may encounter AV
245552  (http://support.microsoft.com/kb/245552/ ) FIX: SH_PAGE lock not released after fetch operation on keyset cursor
245807  (http://support.microsoft.com/kb/245807/ ) FIX: Server unresponsive after deadlocks under tempdb stress
248483  (http://support.microsoft.com/kb/248483/ ) FIX: Client disconnects can cause SQL Server instability when using more than two gigabytes of memory
248764  (http://support.microsoft.com/kb/248764/ ) FIX: DBCC TEXTALLOC may cause SQL Server to stop responding
251333   (http://support.microsoft.com/kb/251333/ ) FIX: Dump database logs flush_cache errors and does not complete
253927  (http://support.microsoft.com/kb/253927/ ) FIX: SP5a regression- Trace flag 1204 causes access violation and server becomes unresponsive
258084  (http://support.microsoft.com/kb/258084/ ) FIX: SPID may stop responding with CPU spin during log out when it drops temp procedure
263661  (http://support.microsoft.com/kb/263661/ ) FIX: Users may unexpectedly encounter FLT_UNDERFLOW_EXCEPTION errors
265838  (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
271835  (http://support.microsoft.com/kb/271835/ ) FIX: SPID may stop responding with status of SPINLOOP during a rollback operation
271841  (http://support.microsoft.com/kb/271841/ ) FIX: Cursor fetches duplicate row after positioned update
271848  (http://support.microsoft.com/kb/271848/ ) FIX: Selection of a text column from keyset cursor defined as join might cause access violation
272426  (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:
197174  (http://support.microsoft.com/kb/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  (http://support.microsoft.com/kb/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  (http://support.microsoft.com/kb/273914/ ) How to obtain SQL Server 6.5 Post Service Pack 5a Update

Applies to
  • Microsoft SQL Server 6.5 Standard Edition
Keywords: 
kbnosurvey kbarchive kbinfo KB274035
Share
Additional support options
Ask The Microsoft Small Business Support Community
Contact Microsoft Small Business Support
Find Microsoft Small Business Support Certified Partner
Find a Microsoft Store For In-Person Small Business Support