Microsoft KB Archive/313980

= INF: List of Bugs Fixed by SQL Server 7.0 Service Packs =

Article ID: 313980

Article Last Modified on 7/13/2004

-

APPLIES TO


 * Microsoft SQL Server 7.0 Service Pack 4
 * Microsoft SQL Server 7.0 Service Pack 1
 * Microsoft SQL Server 7.0 Service Pack 2
 * Microsoft SQL Server 7.0 Service Pack 3

-



This article was previously published under Q313980



SUMMARY
This article provides information about the bugs fixed by SQL Server 7.0 service packs. Because service packs are cumulative, subsequent service packs also fix the bugs fixed by previous service packs. For example, SQL Server 7.0 Service Pack 4 (SP4) has the bug fixes from SQL Server 7.0 Service Pack 3 (SP3), Service Pack 2 (SP2), and Service Pack 1 (SP1).

For additional information about obtaining SQL Server 7.0 service packs, click the article number below to view the article in the Microsoft Knowledge Base:

301511 INF: How to Obtain the Latest SQL Server 7.0 Service Pack



SQL Server 7.0 Service Pack 4
239473 FIX: 70rebind.exe for Windows 2000 and MDAC Upgrades on Clustered SQL Server 7.0 Servers

249730 FIX: SQL Server 7.0 T-SQL Scheduled Task May Take Longer to Run Than SQL Server 6.5 Task

260182 FIX: Unable to Restore to a Point in Time in First Transaction Log Backup

276281 FIX: Replication Logreader Fails with Error Message 18773

280380 FIX: Buffer Overflow Exploit Possible with Extended Stored Procedures

281843 FIX: SQLDMO GetProcessInputBuffer Returns Incorrect Result

282243 FIX: Incorrect Results with Join of Column Converted to Binary

283837 FIX: SQL Server May Generate Nested Query For Linked Server When Option Is Disabled

284351 FIX: SQL Server Profiler and SQL Server Agent Alerts May Fail to Work After Installing SQL Server 7.0 SP3

285870 FIX: Update With Self Join May Update Incorrect Number Of Rows

286788 FIX: Server Side Cursor May Return Incorrect Results

288426 FIX: Alerts Triggered Incorrectly When Security Auditing is Enabled

290629 FIX: Update Query That Uses Star Joins May Cause Access Violation

291561 FIX: Invalid Float Data May Lead to Floating Point Exception and Incorrect Stored Values

293279 FIX: Linked Server SELECT COUNT(*) Sent as SELECT COUNT((0))

293636 FIX: Invoking SQL-DMO Methods By Using &quot;By Reference&quot; Parameters May Cause a Memory Leak

293758 FIX: Nullability Changes Not Handled by SQL Server with Linked Server Queries to DB2

294753 FIX: SQL Server 7.0 Readme Files Do Not Document Installation Warning

295378 FIX: SQLAgent Job with Recurring Schedule is Disabled Upon Completion of the Schedule for the Day

296189 FIX: DBCC SHOW_STATISTICS Truncates Output for Fixed-Length Numeric Types

296456 FIX: Full Text Query May Return 0 Rows When Valid Results are Present

297271 FIX: Point in Time Recovery May Recover Database if the Transaction Log That is Applied Does Not Contain Any Transactions

298643 FIX: Poor Cardinality Estimate for Tables with Multiple Qualifying Histogram Values

298832 FIX: Uppercase Characters are not Sorted Before Their Corresponding Lowercase Characters When You Use the Nocasepref Sort Order

299717 FIX: Query Method Used to Access Data May Allow Rights that the Login Might Not Normally Have

299950 FIX: Bad Cardinality Estimate Results in Sub Optimal Join Strategy

300258 FIX: INSERT EXEC of Extended Stored Procedure Incorrectly Inserts Empty String Instead of NULL

300519 FIX: Problems Occur When Connecting to SQL Server from ADO Application

302615 FIX: Incorrect Cardinality Estimate And Bad Plan for Query with OR and AND on Same Column

302664 FIX: Query with SET NO_BROWSETABLE Option Set ON May Generate Access Violation

302828 FIX: DTS Fails to Transfer Rows When a Non-Sysadmin User Opens Packages from T-SQL with Xp_cmdshell

303344 FIX: Exception Access Violation Encountered in CONSTANT::CONSTANT

303727 FIX: Cancelling Parallel Query May Abort Transaction

304851 FIX: SQL Server Text Formatting Functions Contain Unchecked Buffers

307540 FIX: SQLPutData May Result in Leak of Buffer Pool Memory

307541 FIX: Error 1203 and Failed Assertion Occurs When You Run a Query with a Parallel Plan

308016 FIX: sp_configure 'network packet size' Not Functional in SQL Server 7.0 SP3 and SQL Server 2000

308114 FIX: Query with Multiple Predicates and a Star Join May Cause an Access Violation

308126 FIX: Error 2627 May Cause Sysindexes.rowcnt Field to Be Decremented

308267 BUG: DTS Copy Objects Task (DMO) Breaks Transaction Log Backup Chain By Switching Recovery Mode to Simple During Transfer

308627 FIX: DBCC SHRINKDATABASE or DBCC SHRINKFILE May Expand Database with Text or Image Data

308881 FIX: AV on DECLARE CURSOR with Correlated Subquery and KEYSET or DYNAMIC Cursor Type

310572 FIX: Cursor Type and Column Updatability May Change with Some Sort Orders

311000 FIX: ODBC Functions TIMESTAMPADD and TIMESTAMPDIFF May Cause Error 128

312537 FIX: SQL Server Stops Unexpectedly During Restore

313247 FIX: Existing Users Lose Connectivity If Error Message 17836 Occurs

313661 FIX: Error Message: &quot;Timeout expired&quot; Occurs When You Connect to SQL Server Over TCP/IP and the Kerberos MaxTokenSize is Greater Than 0xFFFF

314117 FIX: Prepare/Execute on Query May Cause Handled Access Violation in CSsNumeric::ConvertFromStr

314971 FIX: Backup of Multi-File Database to Striped Media May Encounter CPU Spin

315938 FIX: SELECT That References Several Tables May Return Invalid TDS Error or Cause Client Application to Stop Responding

316004 FIX: Floating Point Underflow Exception Causes Bad Cardinality Estimate

316976 FIX: Tuning Wizard May Fail When You Specify a Workload File for Non-dbo Owned Objects

317979 FIX: Unchecked Buffer May Occur When You Connect to Remote Data Source

318053 FIX: The EXCEPTION_FLT_INVALID_OPERATION Error Occurs During a Query Compilation

318171 FIX: Binding a Variable to More Than One Output Parameter May Cause an Access Violation

318733 FIX: SQL Server May Become Unresponsive When a Large Number of Databases and Roles are Used

319357 FIX: DBCC CHECKALLOC Enhanced to Detect Allocation Inconsistencies

319507 FIX: SQL Extended Procedure Functions Contain Unchecked Buffers

319690 FIX: Sqldiag.exe Cannot Generate the Winmsd Report on Windows 2000 for the Sqldiag.txt File

319691 FIX: Merge Subscriptions May Reinitialize Unexpectedly If Incremental Schema Change Fails

319693 FIX: A Backup Log with the NO_TRUNCATE Option May Cause an Access Violation

319694 FIX: Uppercase Characters Are Not Sorted Before Lowercase Characters with the Nocasepref Sort Order

319697 FIX: SQL Enterprise Manager Restore to Point in Time Does Not Stop at Requested Time and the Database is Left in a Loading State

319698 FIX: Transform Data Task Might Stop Responding (hang) While Importing Data From Text File

319699 FIX: @@IDENTITY Does Not Process a New Value When You Use INSERT EXEC

319701 FIX: SQL Enterprise Manager RESTORE Msdb Leaves Database in Loading State and Does Not Apply Differential or Log Backups

319704 FIX: Application Error May Occur in Index Tuning Wizard with a Query That Uses Full Text Search Functions

320068 FIX: DTC May Experience a Spinloop That Causes SQL Server to Become Unresponsive

320406 FIX: Procedure Names That Begin with &quot;sp_&quot; Can Fail with an Access Violation

SQL Server 7.0 Service Pack 3
For additional information about the problems fixed by SQL Server 7.0 Service Pack 3, click the article number below to view the article in the Microsoft Knowledge Base:

274797 INF: SQL Server 7.0 Service Pack 3 Fixlist

SQL Server 7.0 Service Pack 2
For additional information about the problems fixed by SQL Server 7.0 Service Pack 2, click the article number below to view the article in the Microsoft Knowledge Base:

254369 INF: SQL Server 7.0 Service Pack 2 Fixlist

SQL Server 7.0 Service Pack 1
For additional information about the problems fixed by SQL Server 7.0 Service Pack 1, click the article number below to view the article in the Microsoft Knowledge Base:

225019 INF: SQL Server 7.0 Service Pack 1 Fixlist

Comments about this or other Microsoft Knowledgebase articles? Drop us a note at [mailto:sqlkb@microsoft.com SQLKB@Microsoft.com]

Additional query words: kbSQLServ700sp4fixlist kbSQLServ700sp3fixlist kbSQLServ700sp2fixlist kbSQLServ700sp1fixlist

Keywords: kbinfo KB313980

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.