Article ID: 313980 - Last Review: July 13, 2004 - Revision: 4.2 INF: List of Bugs Fixed by SQL Server 7.0 Service PacksThis article was previously published under Q313980 On This PageSUMMARY 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
(http://support.microsoft.com/kb/301511/EN-US/
)
INF: How to Obtain the Latest SQL Server 7.0 Service Pack
MORE INFORMATIONSQL Server 7.0 Service Pack 4239473
(http://support.microsoft.com/kb/239473/EN-US/
)
FIX: 70rebind.exe for Windows 2000 and MDAC Upgrades on Clustered SQL Server 7.0 Servers 249730
(http://support.microsoft.com/kb/249730/EN-US/
)
FIX: SQL Server 7.0 T-SQL Scheduled Task May Take Longer to Run Than SQL Server 6.5 Task 260182
(http://support.microsoft.com/kb/260182/EN-US/
)
FIX: Unable to Restore to a Point in Time in First Transaction Log Backup 276281
(http://support.microsoft.com/kb/276281/EN-US/
)
FIX: Replication Logreader Fails with Error Message 18773 280380
(http://support.microsoft.com/kb/280380/EN-US/
)
FIX: Buffer Overflow Exploit Possible with Extended Stored Procedures 281843
(http://support.microsoft.com/kb/281843/EN-US/
)
FIX: SQLDMO GetProcessInputBuffer Returns Incorrect Result 282243
(http://support.microsoft.com/kb/282243/EN-US/
)
FIX: Incorrect Results with Join of Column Converted to Binary 283837
(http://support.microsoft.com/kb/283837/EN-US/
)
FIX: SQL Server May Generate Nested Query For Linked Server When Option Is Disabled 284351
(http://support.microsoft.com/kb/284351/EN-US/
)
FIX: SQL Server Profiler and SQL Server Agent Alerts May Fail to Work After Installing SQL Server 7.0 SP3 285870
(http://support.microsoft.com/kb/285870/EN-US/
)
FIX: Update With Self Join May Update Incorrect Number Of Rows 286788
(http://support.microsoft.com/kb/286788/EN-US/
)
FIX: Server Side Cursor May Return Incorrect Results 288426
(http://support.microsoft.com/kb/288426/EN-US/
)
FIX: Alerts Triggered Incorrectly When Security Auditing is Enabled 290629
(http://support.microsoft.com/kb/290629/EN-US/
)
FIX: Update Query That Uses Star Joins May Cause Access Violation 291561
(http://support.microsoft.com/kb/291561/EN-US/
)
FIX: Invalid Float Data May Lead to Floating Point Exception and Incorrect Stored Values 293279
(http://support.microsoft.com/kb/293279/EN-US/
)
FIX: Linked Server SELECT COUNT(*) Sent as SELECT COUNT((0)) 293636
(http://support.microsoft.com/kb/293636/EN-US/
)
FIX: Invoking SQL-DMO Methods By Using "By Reference" Parameters May Cause a Memory Leak 293758
(http://support.microsoft.com/kb/293758/EN-US/
)
FIX: Nullability Changes Not Handled by SQL Server with Linked Server Queries to DB2 294753
(http://support.microsoft.com/kb/294753/EN-US/
)
FIX: SQL Server 7.0 Readme Files Do Not Document Installation Warning 295378
(http://support.microsoft.com/kb/295378/EN-US/
)
FIX: SQLAgent Job with Recurring Schedule is Disabled Upon Completion of the Schedule for the Day 296189
(http://support.microsoft.com/kb/296189/EN-US/
)
FIX: DBCC SHOW_STATISTICS Truncates Output for Fixed-Length Numeric Types 296456
(http://support.microsoft.com/kb/296456/EN-US/
)
FIX: Full Text Query May Return 0 Rows When Valid Results are Present 297271
(http://support.microsoft.com/kb/297271/EN-US/
)
FIX: Point in Time Recovery May Recover Database if the Transaction Log That is Applied Does Not Contain Any Transactions 298643
(http://support.microsoft.com/kb/298643/EN-US/
)
FIX: Poor Cardinality Estimate for Tables with Multiple Qualifying Histogram Values 298832
(http://support.microsoft.com/kb/298832/EN-US/
)
FIX: Uppercase Characters are not Sorted Before Their Corresponding Lowercase Characters When You Use the Nocasepref Sort Order 299717
(http://support.microsoft.com/kb/299717/EN-US/
)
FIX: Query Method Used to Access Data May Allow Rights that the Login Might Not Normally Have 299950
(http://support.microsoft.com/kb/299950/EN-US/
)
FIX: Bad Cardinality Estimate Results in Sub Optimal Join Strategy 300258
(http://support.microsoft.com/kb/300258/EN-US/
)
FIX: INSERT EXEC of Extended Stored Procedure Incorrectly Inserts Empty String Instead of NULL 300519
(http://support.microsoft.com/kb/300519/EN-US/
)
FIX: Problems Occur When Connecting to SQL Server from ADO Application 302615
(http://support.microsoft.com/kb/302615/EN-US/
)
FIX: Incorrect Cardinality Estimate And Bad Plan for Query with OR and AND on Same Column 302664
(http://support.microsoft.com/kb/302664/EN-US/
)
FIX: Query with SET NO_BROWSETABLE Option Set ON May Generate Access Violation 302828
(http://support.microsoft.com/kb/302828/EN-US/
)
FIX: DTS Fails to Transfer Rows When a Non-Sysadmin User Opens Packages from T-SQL with Xp_cmdshell 303344
(http://support.microsoft.com/kb/303344/EN-US/
)
FIX: Exception Access Violation Encountered in CONSTANT::CONSTANT 303727
(http://support.microsoft.com/kb/303727/EN-US/
)
FIX: Cancelling Parallel Query May Abort Transaction 304851
(http://support.microsoft.com/kb/304851/EN-US/
)
FIX: SQL Server Text Formatting Functions Contain Unchecked Buffers 307540
(http://support.microsoft.com/kb/307540/EN-US/
)
FIX: SQLPutData May Result in Leak of Buffer Pool Memory 307541
(http://support.microsoft.com/kb/307541/EN-US/
)
FIX: Error 1203 and Failed Assertion Occurs When You Run a Query with a Parallel Plan 308016
(http://support.microsoft.com/kb/308016/EN-US/
)
FIX: sp_configure 'network packet size' Not Functional in SQL Server 7.0 SP3 and SQL Server 2000 308114
(http://support.microsoft.com/kb/308114/EN-US/
)
FIX: Query with Multiple Predicates and a Star Join May Cause an Access Violation 308126
(http://support.microsoft.com/kb/308126/EN-US/
)
FIX: Error 2627 May Cause Sysindexes.rowcnt Field to Be Decremented 308267
(http://support.microsoft.com/kb/308267/EN-US/
)
BUG: DTS Copy Objects Task (DMO) Breaks Transaction Log Backup Chain By Switching Recovery Mode to Simple During Transfer 308627
(http://support.microsoft.com/kb/308627/EN-US/
)
FIX: DBCC SHRINKDATABASE or DBCC SHRINKFILE May Expand Database with Text or Image Data 308881
(http://support.microsoft.com/kb/308881/EN-US/
)
FIX: AV on DECLARE CURSOR with Correlated Subquery and KEYSET or DYNAMIC Cursor Type 310572
(http://support.microsoft.com/kb/310572/EN-US/
)
FIX: Cursor Type and Column Updatability May Change with Some Sort Orders 311000
(http://support.microsoft.com/kb/311000/EN-US/
)
FIX: ODBC Functions TIMESTAMPADD and TIMESTAMPDIFF May Cause Error 128 312537
(http://support.microsoft.com/kb/312537/EN-US/
)
FIX: SQL Server Stops Unexpectedly During Restore 313247
(http://support.microsoft.com/kb/313247/EN-US/
)
FIX: Existing Users Lose Connectivity If Error Message 17836 Occurs 313661
(http://support.microsoft.com/kb/313661/EN-US/
)
FIX: Error Message: "Timeout expired" Occurs When You Connect to SQL Server Over TCP/IP and the Kerberos MaxTokenSize is Greater Than 0xFFFF 314117
(http://support.microsoft.com/kb/314117/EN-US/
)
FIX: Prepare/Execute on Query May Cause Handled Access Violation in CSsNumeric::ConvertFromStr 314971
(http://support.microsoft.com/kb/314971/EN-US/
)
FIX: Backup of Multi-File Database to Striped Media May Encounter CPU Spin 315938
(http://support.microsoft.com/kb/315938/EN-US/
)
FIX: SELECT That References Several Tables May Return Invalid TDS Error or Cause Client Application to Stop Responding 316004
(http://support.microsoft.com/kb/316004/EN-US/
)
FIX: Floating Point Underflow Exception Causes Bad Cardinality Estimate 316976
(http://support.microsoft.com/kb/316976/EN-US/
)
FIX: Tuning Wizard May Fail When You Specify a Workload File for Non-dbo Owned Objects 317979
(http://support.microsoft.com/kb/317979/EN-US/
)
FIX: Unchecked Buffer May Occur When You Connect to Remote Data Source 318053
(http://support.microsoft.com/kb/318053/EN-US/
)
FIX: The EXCEPTION_FLT_INVALID_OPERATION Error Occurs During a Query Compilation 318171
(http://support.microsoft.com/kb/318171/EN-US/
)
FIX: Binding a Variable to More Than One Output Parameter May Cause an Access Violation 318733
(http://support.microsoft.com/kb/318733/EN-US/
)
FIX: SQL Server May Become Unresponsive When a Large Number of Databases and Roles are Used 319357
(http://support.microsoft.com/kb/319357/EN-US/
)
FIX: DBCC CHECKALLOC Enhanced to Detect Allocation Inconsistencies 319507
(http://support.microsoft.com/kb/319507/EN-US/
)
FIX: SQL Extended Procedure Functions Contain Unchecked Buffers 319690
(http://support.microsoft.com/kb/319690/EN-US/
)
FIX: Sqldiag.exe Cannot Generate the Winmsd Report on Windows 2000 for the Sqldiag.txt File 319691
(http://support.microsoft.com/kb/319691/EN-US/
)
FIX: Merge Subscriptions May Reinitialize Unexpectedly If Incremental Schema Change Fails 319693
(http://support.microsoft.com/kb/319693/EN-US/
)
FIX: A Backup Log with the NO_TRUNCATE Option May Cause an Access Violation 319694
(http://support.microsoft.com/kb/319694/EN-US/
)
FIX: Uppercase Characters Are Not Sorted Before Lowercase Characters with the Nocasepref Sort Order 319697
(http://support.microsoft.com/kb/319697/EN-US/
)
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
(http://support.microsoft.com/kb/319698/EN-US/
)
FIX: Transform Data Task Might Stop Responding (hang) While Importing Data From Text File 319699
(http://support.microsoft.com/kb/319699/EN-US/
)
FIX: @@IDENTITY Does Not Process a New Value When You Use INSERT EXEC 319701
(http://support.microsoft.com/kb/319701/EN-US/
)
FIX: SQL Enterprise Manager RESTORE Msdb Leaves Database in Loading State and Does Not Apply Differential or Log Backups 319704
(http://support.microsoft.com/kb/319704/EN-US/
)
FIX: Application Error May Occur in Index Tuning Wizard with a Query That Uses Full Text Search Functions 320068
(http://support.microsoft.com/kb/320068/EN-US/
)
FIX: DTC May Experience a Spinloop That Causes SQL Server to Become Unresponsive 320406
(http://support.microsoft.com/kb/320406/EN-US/
)
FIX: Procedure Names That Begin with "sp_" Can Fail with an Access Violation SQL Server 7.0 Service Pack 3For 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
(http://support.microsoft.com/kb/274797/EN-US/
)
INF: SQL Server 7.0 Service Pack 3 Fixlist
SQL Server 7.0 Service Pack 2For 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
(http://support.microsoft.com/kb/254369/EN-US/
)
INF: SQL Server 7.0 Service Pack 2 Fixlist
SQL Server 7.0 Service Pack 1For 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
(http://support.microsoft.com/kb/225019/EN-US/
)
INF: SQL Server 7.0 Service Pack 1 Fixlist
Comments about this or other Microsoft Knowledgebase articles? Drop us a note at SQLKB@Microsoft.com (mailto:sqlkb@microsoft.com) | Article Translations
|
| United States | Change | | | All Microsoft Sites |
Back to the top
|
